…in cache may go away at any point”, this can result in painful …memcache node). This is where a persistent cache can be invaluable. Enter MySQL …/ 100000; $timer->start(); for ($i = 0; $i < 10; $i++) { for ($i = 0; $i < 100000; $i++) { $obj = $cache->load(“key_$i“); } } $totalTimeFetch = $timer->stop…
Post: Sphinx search performance optimization: attribute-based filters
January 15, 2013 By 11 Comments
… great for full text search, you can certainly go beyond full text search, but before you go there, it is a good idea… And now I have an extra column in a full text index that I can use for filtering: sphinx> select * from catalog where match…) That looks much better and I can mix it with other search keywords: sphinx> select * from catalog where match(‘Great @userkey userkey_50…
