…’m especially interested about it is Sphinx which is currently implemented as storage engine for MySQL but this role does not suite…. I’m saying about Prepared Statements in MySQL 4.1 which came without query cache support but even worse not all of statements… for very long time. For example Query Cache support for Prepared Statements is only fixed in MySQL 5.1 and Most of other…
Post: Sphinx search performance optimization: attribute-based filters
January 15, 2013 By 11 Comments
… in 155ms. Doing the same thing in MySQL, assuming user_id is indexed and in cache, would take less than a millisecond… some different queries against the two: sphinx> select * from catalog where ancient = 1; | total_found | 1499266 | 14% | time | 0.552 | sphinx> select * from… in queries without full text search keywords, having them full text indexed is a very good way to improve such Sphinx search query…
