Fulltext boolean search for vB v.1.5

[JohnWoo]

Hello all!

Please check for new versions here
https://vborg.vbsupport.ru/showthread.php?t=62282
:)

[TheComputerGuy]

Sweet...any more details?

[gmarik]

Has anybody got it working?

[JohnWoo]

any problems or error messages ? :)

[Andreas]

> You will need MySQL server v3.23.23 or better.
I think you will need at least mySQL 4.0.1 as you are using IN BOOLEAN MODE modifier ...

[JohnWoo]

it is true, that Mysql documentation says that IN BOOLEAN MODE was added in 4.0.1
but for some strange reason it works (I tested it) on 3.23.26 (locally), 3.23.52 (2 different servers) and 3.23.56 (4 different servers)
Using "Beta Releases" forum because of such strange things :)
But yes.. i have to mention it in txt file :)

[xware]

ALTER TABLE post ADD FULLTEXT (pagetext);

I have run this sql, but how to uninstall it?
Plese help! URGENT!

[JohnWoo]

ALTER TABLE post DROP INDEX pagetext;

? :)

[xware]

this hack can not work with large database. When you post a thread it should insert into post and make a index for all posts.

[JohnWoo]

then question :)
how much posts must have "large database"?
I can't say that it is completely tested, but on my side server load seems to become 10-15% less on 2 forums (one with more then 200000 posts and second with about 2000 posts). May be because on both that forums much more people search then post - not sure...
And yes. Posting takes more time, but it don't "make a index for all posts" :) It update existing index.

[xware]

200000 posts on my board and I can't fix this problem now.
I drop the INDEX pagetext on post but too heavey to mysql.

[JohnWoo]

posting process heavy?
strange... May be you have any benchmarks on server or in vB and got some numbers?
PS what MySQL version you have?

[goyo]

Maybe i'm stupid...but this modification should lower the server load...

Anybody has experience with this ?

[xware]

I DROP INDEX pagetext today and all are normal. But I try and taken 15 hours to do this thing, the mysql process is too heavy......
It's a nightmaire for me.......