optimization - reordering mysql table rows to increase speed -


i have mysql table has bunch of words. words more common others, selected more commonly.

at moment table ordered alphabetically, however, if order rows based on frequency/commonness of word , make sure there's limit on queries, make selects faster overall? (given common queries faster)

i mean 'hard' reorder rows, not order by in query.

some basic info table:

row         statistics format      dynamic collation   utf8_general_ci rows        106,827 engine      myisam 

you want create index on column holds words select by. otherwise mysql scan entire table.


Comments

Popular posts from this blog

How to mention the localhost in android -

php - Calling a template part from a post -

c# - String.format() DateTime With Arabic culture -