RE: Lots of searches

2005-02-18 Thread gunmuse
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

Re: Lots of searches

2005-02-18 Thread Brent Baisley
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