… underlying reason why this is not efficient. WHERE FT_QUERY_1 AND FT_QUERY_2 seems to be OK, but “OR” seems… helps someone. Also, reasonable results can be achieved by using BOOLEAN queries to restrict, and expressions to sort. AFAIK, natural FTS can… reasonable success with MySQL 5.1 and 100k+ product rows. Sphinx is better in some ways, but FT is fairly mature…

…=date (in boolean mode sorting by date descending returning top 200 matches): — PROFILE — root: 8.81, self: 0.00 query_load_dir… no boolean search available in sphinx, defaulting to SPH_MATCH_ALL) returning top 200 matches): — PROFILE — root: 12.86, self: 0.00 query…: 0.04 query_match: 12.82, self: 11.51 read_hits: 1.31 ————— Even if the new SPH_MATCH_BOOLEAN is an…

… SPH_MATCH_BOOLEAN if you do not care about relevance end just want to check if there is the match. Sphinx would… slow. About sphinx – it would be interesting to see which performance do you get if you’re using boolean match mode as it looks like what you need. Also benchmark using real queries from your site…

7. peter: All results have been performed in boolean search mode. That is because in my case the client … there exist any other matches which still fulfill the search query because the fulltext engine has on its own made up… words” search the mysql fulltext in boolean mode takes more than 800 seconds on this hardware, sphinx takes approx 16 seconds, bitvector…

… SQL query, for full text search systems results are often different, depending on relevance computing method. If you’ve been using sphinx… based search you should use boolean match mode – this bypasses all word position check logic. Note Sphinx at this moment builds index… pretty interesting to see what numbers do you get for boolean search in sphinx.

… results have been performed in boolean search mode. Does that mean using -b command line option to Sphinx search utility? > fulltext engine…’t know what’s your experience with other engines, but Sphinx never does that. In it’s default mode, it will… case running time. However an average query won’t typically be that hard to evaluate. > sphinx takes approx 16 seconds, My thinking…