[Solved] Perfomance difference between utf8_unicode_ci and utf8_general_ci

[cheval venus]

Hi folks,
I work for a company which is migrating the database. We are using Mysql 5.
We have almost 60Go of data encoded into latin1_swedish_ci. And we have a lot of traffic.

I read a lot of stuff which explain the difference between UTF8_unicode_ci and UTF8_general_ci.

I understand all the data differences, sort differences, etc... which comfort my choice using unicode.

But, at the end of each explanation, I can find the last sentences, which says : general is faster than unicode. But I can't find any information about the difference of performance.

So if someone, can explain me or provide me a link which show some results of some searches on a 10 millions rows table with a request using a like and some strange char. I will be happy.

Thanks.

Jeremie



Edited 1 time(s). Last edit at 08/23/2010 08:29AM by cheval venus.