0

I read this difference between utf8_general_ci and utf8_unicode_ci

and @thomasrutter said that utf8_unicode_ci is slow when it comes to sorting. Then my question is how will I fix that. So I can improve the sorting speed while using utf8_unicode_ci. I want to transfer my collation in utf8mb4 that's why I am curious.

EDIT

It is not the same, what my question here is how to fix the slow sorting of utf8mb4_unicode_ci and I dont have ask question here what is the difference between utf8mb4_unicode_ci and utf8mb4_general_ci. Please, reconsider.

Community
  • 1
  • 1
phew
  • 147
  • 2
  • 10
  • No it is not, what my question is how to fix slow sorting in `utf8mb4_unicode_ci` not comparing it to `general` one – phew Jun 09 '16 at 13:12
  • How to fix slow sorting... is too broad... it still does not fit SO guidelines. – Rosdi Kasim Jun 09 '16 at 16:30
  • There is a difference between "it is slower" and "it is slow." It is slower by comparison because it is more complicated to sort, for the same reason that sorting case-intensive is slower than sorting binary -- there are more rules. – Michael - sqlbot Jun 09 '16 at 23:20
  • @Michael-sqlbot thanks, I read a post in stackexchange.com that it takes 10s to sort a small table, so that's why I am hesitating to use `utf8mb4_unicode_ci` – phew Jun 10 '16 at 01:23
  • There are a lot of people who don't understand database indexes. [Use the Index, Luke](http://use-the-index-luke.com/) -- then it becomes largely irrelevant how long it takes to sort, because the database simply reads from the index, which is already sorted -- the sorting is done at insert/update, not select, and so any added processing cost is amortized over time to the point that it becomes uninteresting. – Michael - sqlbot Jun 10 '16 at 02:54
  • 1
    "10s to sort a small table" -- I don't believe it; can you provide a link? – Rick James Jun 24 '16 at 16:08
  • If you need the `unicode` collation, use it. – Rick James Jun 24 '16 at 16:08

0 Answers0