Page 1 of 1

How slow/fast is MySQL Fulltext Boolean Search??

Posted: Fri Sep 10, 2004 11:53 am
by LEGbEND
I havent been able to test the speed of the search on a fully populated table, so I was wondering how fast the MySQL Fulltext Boolean search is?

How much of a strain does it put on the server?

I have it set to search 2 Fields of a 6 Field table. One field containing a description and one containing keywords.

Table will have about 16,000 entries.

Thanks!


ps. I've been using these forums for help for the last month or so, just decided to sign up. :)

Posted: Fri Sep 10, 2004 1:22 pm
by feyd
why not try it, since each server can produce quite differing time results..

Posted: Fri Sep 10, 2004 1:37 pm
by Breckenridge
If you are using your own server you should get fast results. if you are sharing a host with 50+ other sites mysql can be demanding of your sever when you are searching 16k+ entries. I'm using on a site that searches 6000 entries and it does very good.

Posted: Fri Sep 10, 2004 2:26 pm
by LEGbEND
It's our own server. Dual Xeon's, 2GB Ram, (hope to put 4GB), SATA drives...

Think it should be ok?

Posted: Fri Sep 10, 2004 2:28 pm
by feyd
should be fine.