开发者

Case insensitivity for DB Collation - does it affect performance?

Earlier on while I was working on my databases, I wondered if using a case sensitive collation like utf8_bin would increase performance over case insensitive collaction like utf8_general_ci (examples are from MySQL).

Does anyone have any comment on this? What about databases oth开发者_Python百科er than MySQL?


Yes, a binary collation will be faster then others. How much, I can't say.

A binary sort or compare is simpler than dealing with case (+ accent, kanatype and width in SQL Server).

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜