Clever Geek Handbook

Sorting problem

If I change the default setting for the table type in UTF8 from Latin, will it slow down the queries?

+2


source to share


2 answers


As always with character sets (and sorting shouldn't matter too much), it depends.

Long answer:

If I am not mistaken (someone can correct me), the only performance difference this could cause would be a different size of the stored data. And it depends on your saved data. If you are storing mostly English text, then UTF-8 strings will be the same as latin1 strings, but for languages ​​such as French, UTF-8 strings can be longer than the special character set. But this effect is only significant when storing Russian, Arabic, CJK, etc.



The short answer is:

Not.

+3


source


I don't know of any reason why this is necessary, but the fundamental answer to something like this is to "test it and see" - that is, figure out how long your queries are taking now, change the sort, and find out how long they will be afterwards. ...



+1


source






More articles:


All Articles