Sphinx Search

[amcd]

because it returns only 500 results?

[Simetrical]

So you're saying that if the number of results is limited, they won't be sorted by date before they're limited, but after? Is there any way to fix that? Alternatively, if I just increase max_matches to 2000 or something, that's probably not going to be a big problem, right?

[amcd]

I really don't know. I am just thinking aloud.

[Spinball]

Just wanted to post a note here to thank the folks who pointed me to Floren Munteanu's Sphinx solution which is now installed at www.AVForums.com.
I was so impressed that I made a video at http://www.youtube.com/watch?v=zJkVHcqfEBQ (choose the HD version).
Thanks, guys.

[mlx]

Originally Posted by Spinball

I was so impressed that I made a video at http://www.youtube.com/watch?v=WIdsOA_hFpM (choose the HD version).
Thanks, guys.

LOL unless you are too stupid to setup a cronjob correctly it's plain and simple wrong that the search index only updates every day using the free solution.

[Spinball]

Originally Posted by mlx

LOL unless you are too stupid to setup a cronjob correctly it's plain and simple wrong that the search index only updates every day using the free solution.

Ok it was every day when I last used it. Have things changed since then? Apologies if so. Please let me know and I will change the video.
As I understand it, though the Sphinx reindex in the free solution was quite server intensive and took a while?
(By the way there is need to be offensively defensive about the free solution - we used it for ages and I'm not running down the efforts that people have put in for free).

[snakes1100]

You set the cron to run when you want it to run, it was never locked to 1 day that i was aware of and i've ran it since the first free release here.

Server "intensive", that would depend on your hardware.

[mlx]

Originally Posted by Spinball

Ok it was every day when I last used it. Have things changed since then? Apologies if so. Please let me know and I will change the video.
As I understand it, though the Sphinx reindex in the free solution was quite server intensive and took a while?
(By the way there is need to be offensively defensive about the free solution - we used it for ages and I'm not running down the efforts that people have put in for free).

Sure, re-indexing all configured indexes will take some time and might be quite server intense on a database with millions of posts. So are you saying that the paid solution is running "indexer --all --rotate" to re-index all configured indexes every 20 minutes in no time?

Or is it updating the delta indexes every 20 minutes pretty much as described here in 2007?

[Spinball]

Originally Posted by mlx

Sure, re-indexing all configured indexes will take some time and might be quite server intense on a database with millions of posts. So are you saying that the paid solution is running "indexer --all --rotate" to re-index all configured indexes every 20 minutes in no time?

Or is it updating the delta indexes every 20 minutes pretty much as described here in 2007?

Honestly I don't know. And that's the point, really. The wife and me own our forums and with the development, marketing and admin jobs I do, I plain don't have the time to understand the details of the search, either the free one here or the paid one. That's why I paid someone else to sort it all out for me.
All I know is that the indexes are updated every 10 minutes and the load on the servers is not significant.
In the free solution running on our forums, it was reindexing every day because that's how I set it up based on what information I could get out of this thread a few months ago. Maybe it wasn't set up as optimally as it could, but then that's because I found this thread to be a bit overwhelming and the instructions a bit complex. Least ways that's how I felt about it.
Most forum admin are not programmers or database experts, or particularly want to be, I would imagine. Or, in many instances, have the funds to pay someone else to do it.

That's why the free plugins released here which install with zero technical ability are so popular.

[mlx]

I see.

Still ... the point is that the free solution can be setup the same way. Our search index is updating every 5 minutes without any significant load too. Rebuilding all indexes is a totally different thing. That setup is totally based on the free information within this thread.

That's probably the reason for the slightly offensive post earlier today ... sorry for that