Sphinx Search

[weeno]

Originally Posted by orban

Have you created the sphinx_counter table?

yeah... I think it has to do with 4.0.x not allowing nested SELECT queries. (subqueries).

that support didn't come until 4.1.

arn

[orban]

Oh. Try asking in the sphinx forums maybe there's a way to avoid the nested queries.

[amcd]

followed the howto and installed flawlessly in one shot

the first look is very very encouraging

will report again after few days

btw, my forum is Threads: 85,829, Posts: 3,686,297, Members: 175,810

[orban]

Glad to hear

[mute]

Our search is working flawlessly, and seeing ~4000 searches per day, which isn't too shabby at all.

Question for you guys, as I can't seem to find much in the way of documentation regarding the searches.

Does sphinx support "OR"? If you were to search for "test one two", it searches for all three with an implicit "AND". If you search for "blah not bleh", it will search for "blah -bleh". If you search for "test or task or mask", it will search for that literally (and likely ignore "or" as one of my stopwords)

Anyone? A couple of my more picky users are complaining, and I don't really have an answer for them, as I typically just do keyword searches.

[amcd]

can we go one step deeper on this delta thingy?

main index - rebuilt once every day or maybe twice a week
delta 1 - rebuilt once every hour or maybe 4 times a day
delta 2 - rebuilt every 5 minutes

is it possible? will having the index in 3 parts affect performance?

[mute]

Originally Posted by amcd

can we go one step deeper on this delta thingy?

main index - rebuilt once every day or maybe twice a week
delta 1 - rebuilt once every hour or maybe 4 times a day
delta 2 - rebuilt every 5 minutes

is it possible? will having the index in 3 parts affect performance?

There really isn't a point in doing so. I run my delta updates every 5 minutes, and it takes ~1 second, and I get about 450 new posts per minute..

[amcd]

Originally Posted by mute

There really isn't a point in doing so. I run my delta updates every 5 minutes, and it takes ~1 second, and I get about 450 new posts per minute..

oh. then i suppose the current 2 level system is fine.

how often do you rebuild the main index? i have set it up for once a day.

[ALanJay]

Originally Posted by amcd

how often do you rebuild the main index? i have set it up for once a day.

I rebuild my once a day at the slowest part of the night. Which seems to be fine. The delta is run every 5 minutes and takes a few seconds to create. We have between 10-40,000 new posts a day.

[mute]

Originally Posted by amcd

oh. then i suppose the current 2 level system is fine.

how often do you rebuild the main index? i have set it up for once a day.

I personally have no plans on rebuilding my main index on a regular basis. Given the nature of the way this delta update stuff works, there is really no penalty to letting your delta updates grow in size, so I don't plan on rebuilding my index until sometime in the future that we have a maintenance window or something like that.