[RedWingFan]

Originally Posted by eoc_Jason

Switching to InnoDB is not really a viable option... Can you imagine how many more threads there will be specifically for InnoDB tuning? As if the people whom didn't have a clue about my.cnf before are going to magically make this work... lol.

A lot of us have already been using InnoDB for years, so it's nothing new. It is always accounted for when we submit to tweaking threads over at vb.com . At many hosts though, InnoDB is nowhere near optimized and, if you're on a shared account, you can't get MySQL tweaked anyway. Folks with boards that small really don't need InnoDB though. (Although I found with the old phpBB2, I did need to change a couple of tables to InnoDB since it was locking for a minute at a time.)

Originally Posted by eoc_Jason

I do not plan on even looking at 4.0 for a while... People just have too many negative things to say right now and there are still too many bugs....

Unfortunately I'm only interested in a 4.0 implementation--Sphinx is the only major reason now that we won't switch our boards over. The 3.x version works good enough for us. I'm at the "don't give a crap" point now with the forum owner. The members can like what they have with Sphinx, or just shut the **** up, IMHO.

Originally Posted by mute

My guess is that they aren't happy with the "search lag" associated with using Delta indexes, and that's why they are holding back. There are realtime updates for Sphinx in the pipeline, but it's not stable yet.

I run deltas every two minutes. The server barely feels it--the posts and threads index in less than a second. If you think about it, how often do you go searching for posts that were made in the last few minutes? Rarely at all. I couldn't care less if there are real time updates via Sphinx. Nobody has complained they can't find a post they made five minutes ago.

Originally Posted by mute

I think the only "difficult" part about the whole deal will be setting up Sphinx for people who are cpanel-junkies.

Good point. I won't even consider a host that uses that Cpanel crap. I've had to use a few for clients who had existing sites I was working on, and it just frustrated me having a lack of control over many things. Give me SSH and SFTP and that's all I need. I've done it that way for 13 years.

Originally Posted by eoc_Jason

I've been writing things out and reading over the sphinx documentation with a fine tooth comb. Sphinx DOES support Boolean mode, along with like half a dozen other methods. One thing I plan on doing is offering ALL the features on the vB search page, so no template edit required there to strip things down or remove features... Also I'm going to try and implement the various search modes based on how a user inputs their search criteria... i.e. if they use quotes "This must match exactly" then it will use a phrase search.

I noticed the same thing when I went over Sphinx's documentation a couple of months ago--there are so many options for both searching AND indexing that it seems a shame we are only able to use part of it. Phrase-based searching (with quotes), boolean, etc., would be a huge jump over what the default offers.

If it doesn't cripple anything, I would not mind beta testing any new search facilities that crop up here on our 3.x production forum. (Specs below, per your request. ) For the 4.0, since it is private, I'm willing to try anything at this point. The staff doesn't mind helping me out on the user end of things, and they seem to find quirks I can never generate on my own.

Our forum: 200,000 threads; 4.6 million posts; 22,000 members. Running vB 3.7.x but looking to upgrade to 3.8.latest since we got the license upgrade several weeks ago.