The memory deal gave me an idea. A little hotcopy to a Memory table once a day and perform the search from there. Since the search is a nicity for the users and not critical to be 100% accurate or up2date.
How do you do a hotcopy with php then? Never even seen it done. Thanks Donny Lairson 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 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
