WordPress.org

Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #21435, comment 11


Ignore:
Timestamp:
03/06/2014 09:32:30 PM (8 years ago)
Author:
SergeyBiryukov
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #21435, comment 11

    initial v1  
    88Yes. Japanese.
    99In this case, the column is not binary so index is constructed with 2 words.
    10 Japanese characters are almost 50,000 words so that index tree would have maximum 50,000^2 node when using depth 2 BTree index.
     10Japanese characters are almost 50,000 words so that index tree would have maximum 50,000!^2 node when using depth 2 BTree index.
    1111
    1212If other users does not have this kind of performance problem, index length should be minimum.