mySQL and full text indexing

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: Josh Coffman
Date:  
To: plug-discuss
Subject: mySQL and full text indexing
Hi,

Anyone have an experience or opinions on full text indexing with MySQL? We currently use MS SQL with full text indexing, and its a pain.
We are preparing for our db to add tens of millions of rows soon; currently those tables are in the 600,000 - 800,000 range. So its a big jump.
This data is fed to us and reloaded nightly. This data is used by websites, and traffic increases with time.

I'm concerned about performance in general, especially in text searches. In case the topic starts to come up, I'd like to have any idea how MySQL
well would handle something like this. Or PostGre for that matter. Any difference between running those DB's on linux versus Windows?

Thanks
-j








---------------------------------------------------
PLUG-discuss mailing list -
To subscribe, unsubscribe, or to change you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss