… filesort. The solution for this problem is ether extending your indexes so MySQL Optimizer does not have …use indexes, even if it is quite fast: mysql> explain select * from test order by k limit 5; +—-+————-+——-+——-+—————+——+———+——+———+——-+ | id …
Post: Sphinx search performance optimization: attribute-based filters
January 15, 2013 By 11 Comments
… text columns are always indexed and using the very powerful extended query syntax you can do search against certain columns only… first time, it maybe a little confusing, but let me explain. Query returned 20 rows because unless you specify an explicit…
