There's nothing you can do except get really fast hard drives. Since
you are searching for random parts of words you can't use an index. So
you're stuck with doing a full table scan. Your entire table probably
won't fit in memory, so you will be reading from disk. Thus, fast disk
drives in a RAID setup.
On Feb 18, 2005, at 1:56 PM, <[EMAIL PROTECTED]> wrote:
We want to be able to search through 1 million words looking for
matches and a count of how many times they have been searched.
Example. Words like:
guns
shotguns
longguns
long guns
shot guns
So I want to search all million words for the use of the word 'gun'
Then it would return me those 5 phrases since the pattern gun is in
the phrase.
My question is what is the best way to setup the db to make this
search as fast as possible. Right now its taking 45-50 seconds and I
would like to get it down to 4-5 seconds.
Thanks
Donny Lairson
President
29 GunMuse Lane
P.O. box 166
Lakewood NM 88254
http://www.gunmuse.com
469 228 2183
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
