…EXPLAIN EXTENDED to see that MySQL rewrites the view query to include the restriction: mysql> explain extended… | key_len | ref | rows | filtered | Extra | +—-+————-+——-+——+—————+——+———+——-+——+———-+————————–+ | 1 | SIMPLE | t2 | ref…
Post: Sphinx search performance optimization: attribute-based filters
January 15, 2013 By 11 Comments
… find our customers face is misuse of search filters. In this article I will cover how Sphinx … are always indexed and using the very powerful extended query syntax you can do search against certain …, it maybe a little confusing, but let me explain. Query returned 20 rows because unless you specify …
