Sphinx Search

[NickCat]

Originally Posted by orban

Wrap "if (is_array($vbulletin->GPC['prefixchoice'])) { .... }" around the that block



Are you sure the sphinx_counter table is set up properly



Change the line with "$searchhash" to "$searchhash = md5(microtime());"

Try if that works



The newer Sphinx versions are much more complex... how large are your indices? I haven't noticed anything...

I'm going to retry the upgrade this weekend.

I will make those edits and see what we get for changes as far as the errors.

The sphinx_counter was working properly, it was updating both counters each time I ran the indexer, it just wasn't adding any info to the deltas.

As far as the speed, my board is 21+ million posts. I could be mistaken, but the size difference seemed rather significant between the two setups.

My indices right now with the old version are as follows:

-rw-r--r--  1 root root 6804366226 May  6 02:27 fulltext.spd
-rw-r--r--  1 root root        276 May  6 02:27 fulltext.sph
-rw-r--r--  1 root root   25592581 May  6 02:27 fulltext.spi
-rw-------  1 root root          0 May  6 02:28 fulltext.spl
-rw-r--r--  1 root root          0 May  6 02:12 fulltext.spm
-rw-r--r--  1 root root 1960560103 May  6 02:27 fulltext.spp
-rw-r--r--  1 root root          0 May  6 12:05 fulltextdelta.spa
-rw-r--r--  1 root root    1092441 May  6 12:05 fulltextdelta.spd
-rw-r--r--  1 root root        276 May  6 12:05 fulltextdelta.sph
-rw-r--r--  1 root root      88374 May  6 12:05 fulltextdelta.spi
-rw-------  1 root root          0 May  6 12:05 fulltextdelta.spl
-rw-r--r--  1 root root          0 May  6 12:05 fulltextdelta.spm
-rw-r--r--  1 root root     320815 May  6 12:05 fulltextdelta.spp
-rw-r--r--  1 root root          0 May  6 02:28 thread.spa
-rw-r--r--  1 root root   82741228 May  6 02:28 thread.spd
-rw-r--r--  1 root root        221 May  6 02:28 thread.sph
-rw-r--r--  1 root root     768559 May  6 02:28 thread.spi
-rw-------  1 root root          0 May  6 02:28 thread.spl
-rw-r--r--  1 root root          0 May  6 02:28 thread.spm
-rw-r--r--  1 root root   10011490 May  6 02:28 thread.spp
-rw-r--r--  1 root root          0 May  6 12:05 threaddelta.spa
-rw-r--r--  1 root root       9361 May  6 12:05 threaddelta.spd
-rw-r--r--  1 root root        221 May  6 12:05 threaddelta.sph
-rw-r--r--  1 root root       3139 May  6 12:05 threaddelta.spi
-rw-------  1 root root          0 May  6 12:05 threaddelta.spl
-rw-r--r--  1 root root          0 May  6 12:05 threaddelta.spm
-rw-r--r--  1 root root       1298 May  6 12:05 threaddelta.spp

I will report back with size of the new ones once I get a chance. It takes about 30-45 minuted for me to reindex the entire site. I used your new config as well, making the necessary edits, when I ran the setup, so that obviously changed the name of some things, but postdelta and thread delta remained the same. The speed difference may have just been perception though, since your script runs through the redirect and the search_sphinx.php I am currently using skips the redirect entirely.