I just set up 0.9.8 on my 3.6.8 forum (nasioc.com) and we have just over 20 million posts. So far the performance increase is night and day. I'm using the sphinx.php from weeno and everything seems to be working well.
There is a results issue I can't quite understand.
I have a max_results of 5000 in my sphinx.conf, and my vbulletin is set to display 2500 results.
When I search a very common word (raw results from search on fulltext are 982507) on my site and display the results as threads, I get about 581 results. If I search the same term and display as posts I get the full 2500 results. I'm presuming this is because it's finding raw posts with my word in it and condensing that 2500 posts by grouping them into the proper threads. Is that correct?
Is there anyway to ask sphinx to actually return 2500 threads instead?
Otherwise things seem to be running quite smoothly... to have gone from searches that were taking upwards of 60 seconds to this is a dream come true. Now it's just a matter of working out the kinks.
Has anyone produced a newer example sphinx.php for 0.9.8 yet?
|