Mysql 'booloean' search vs vBulletin 'boolean' search

[telc]

The Mysql Natural Language Search is less CPU intensive then the Vbulletin search.

But how does the Mysql 'Boolean' search compare to the Vbulletin search?

Is the Mysql 'Boolean' also more efficient then the vBulletin search, just not as efficient as the Mysql Natural Lanuage?

I am asking this question, because I am getting ready to upgrade to 3.5 on a very large forum

[denby]

I would like answers to Telc's questions too.

I have the default vB builtin search method at the moment. I run 3.5.4 with these current stats:
Threads: 34,569
Posts: 362,987
Members: 32,150
database size: 530Mb
We get about 1900 new posts per day. I have a single processor P4 dedicated server, but I may be moving to a dual processor Zeon dedicated server soon to cope with the operation of a soon-to-be-installed Coppermine gallery.

It sounds like Fulltext Natural does not give as accurate results as Fulltext Boolean (or vB Search) [http://www.vbulletin.com/forum/showthread.php?t=175471] so Fulltext Boolean is the only sensible alternative to vB Search in my opinion. With my forum size and activity, can anyone advise whether the Fulltext (Boolean) method is going to be less server intensive/faster than vB Search:

1. on my current server
2. on the Zeon server

Thanks.

[Freddie Bingham]

It is difficult to say which will be faster and which will be less server intensive. It depends on the forum content and what is being searched for on average.

All I can suggest is that you try both options out.

[denby]

OK: so it's too close to call at my current size? If so, I think I'll leave it for now.

At what forum size threshold do you recommend switching to Fulltext (when vB Search just can't cope anymore)?

[telc]

I figured I would bump this to see if anyone else with a large 4,000,000+ post high volume (400+ users) boards.

Has anyone switched from vb search to mysql Boolean search and saw an improvement?