How slow/fast is MySQL Fulltext Boolean Search??

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
LEGbEND
Forum Newbie
Posts: 2
Joined: Fri Sep 10, 2004 11:46 am
Location: socal

How slow/fast is MySQL Fulltext Boolean Search??

Post 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. :)
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

why not try it, since each server can produce quite differing time results..
Breckenridge
Forum Commoner
Posts: 62
Joined: Thu Sep 09, 2004 11:10 pm
Location: Breckenridge, Colorado

Post 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.
LEGbEND
Forum Newbie
Posts: 2
Joined: Fri Sep 10, 2004 11:46 am
Location: socal

Post by LEGbEND »

It's our own server. Dual Xeon's, 2GB Ram, (hope to put 4GB), SATA drives...

Think it should be ok?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

should be fine.
Post Reply