Sphinx Search

[Neil Lock]

Hey All,

Mentioned way back was a possible solution for getting posts per userid into sphinx - has actually implemented this or does anyone have any other ideas - im pretty sure that some of the remaining slow queries in my board relate to this functionality and would be curious to see what people are doing?

btw the sphinx engine is running amazingly we are averaging now just under 10000 searches on it a day and its had no real issues!

Cheers

Neil

[amcd]

ALanJay, did you finally solve the problem? I upgraded php yesterday, and now my search doesn't work. All searches return zero results.

edit: It works now. The unpack31 trick did it.

[ekool]

I have this working but seem to be running into a strange issue..

When I search for the same word more then once, I get the following:

 Search took 0.32 seconds; generated 50 minute(s) ago.

So, it appears that once I search for a particular keyword, it never "renews" the search and instead always shows the old results that were generated a long time ago?

[rix]

that's because u set the search to share result.

Options->Message Searching Option->Search Result Sharing

[ekool]

Originally Posted by rix

that's because u set the search to share result.

Options->Message Searching Option->Search Result Sharing

Yup, your right. Thanks.

Originally Posted by mute

erm yeah, it's $Coventry. We don't use it, so that is probably why. For now i just set error_reporting to 0 and it went away

I do not see an error_reporting in the php files? How did you disable it?

[amcd]

I do not see an error_reporting in the php files? How did you disable it?

its in php.ini

most vbulletin scripts also set it in the first few lines like this:

// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);

[TECK]

orban, I have a question. Did you patched and compiled MySQL 5.x as described in the readme file?
http://www.sphinxsearch.com/doc.html#sphinxse

I'm about to build an RPM for MySQL with SphinxSE. I think is good we test everything in this direction also, it should increase performance since everything is directly build into MySQL.
Let me know what you think. Thanks.

[orban]

No, I'm not using SphinxSE. Afraid.

[mute]

Has anyone figured out a fix for the "out of order" results issue yet?

[kmike]

Originally Posted by mute

Has anyone figured out a fix for the "out of order" results issue yet?

The fix is to use sort_search_items() function where appropriate.