Lots of searches

[gunmuse]

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