Ghan_04
Active member
So I'm testing Xenforo on my imported vBulletin 4 forum. Did the cache rebuilds and the reindexing, etc. So here we go with MySQL fulltext searching being completely retarded:
When can we expect a faster search solution like Sphinx for Xenforo? Same search on the vBulletin install with Digital Point's Sphinx search took me 2.43 seconds.
# Time: 111201 18:33:37
# User@Host: <some cool user> @ localhost []
# Query_time: 21.635383 Lock_time: 0.000018 Rows_sent: 200 Rows_examined: 10928
use test_xenforo;
SET timestamp=1322786017;
SELECT search_index.content_type, search_index.content_id
FROM xf_search_index AS search_index
WHERE MATCH(search_index.title, search_index.metadata) AGAINST ('+hero*' IN BOOLEAN MODE)
ORDER BY search_index.item_date desc
LIMIT 200;
When can we expect a faster search solution like Sphinx for Xenforo? Same search on the vBulletin install with Digital Point's Sphinx search took me 2.43 seconds.