President
29 GunMuse Lane
P.O. box 166
Lakewood NM 88254
http://www.gunmuse.com
469 228 2183
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Friday, February 18, 2005 1:41 PM
To: [EMAIL PROTECTED]
Cc: Mysql
Subject: Re: Lots of searches
There's nothing you c
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 RA
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
