Official Mys v1.4.0 Ideas & Suggestions Thread

[IntoRain]

Originally Posted by Kyttias

^^; Will it still be negligible at 6,000 users?

Honestly, I've used varchar in most of my projects and queries took no longer than a few seconds with a few thousands auto-generated fake data entries. Query speeds actually depended more on the instruction I was doing (lost of joins, constraints, etc.) and if I had indexes to speed up selects.

I mean if you are only getting a person's gender, yes it will be faster, but in mysidia you usually get the whole row (since you are building objects). If you are getting a row where a column is a char and another is a varchar, you will get no performance improvements
But if you are indexing tables with columns that can be either char/varchar, go with char.


Again, talking on personal opinion about speed difference xD I still agree with you the gender and other columns should be changed anyway