List:General Discussion« Previous MessageNext Message »
From:Don Read Date:May 1 2003 5:10am
Subject:RE: optimize ...
View as plain text  
On 01-May-2003 Jimmy Brake wrote:
> i have a table that has 1.22 million rows that takes 30+ seconds to run
> a very simple query on
> 
> mysql> select article_id from c_search where word = 'foo' and field =
> 'ISRG';
> Empty set (32.91 sec)
> 
> 1 gig of ram + 1 gig cpu 
> 
> how do make this take .01 seconds WITHOUT throwing hardware at it?
> 
> thanks ....

Any index on 'word' or 'field' ?


-- 
Don Read                                       dread@stripped
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.
                            (53kr33t w0rdz: sql table query)

Thread
optimize ...Jimmy Brake1 May
  • RE: optimize ...Don Read1 May
  • Re: optimize ...Santino1 May
  • re: optimize ...Egor Egorov1 May
    • re: optimize ...Jimmy Brake1 May
      • re: re: optimize ...Egor Egorov2 May
        • re: re: optimize ...Hardik Doshi2 May
  • Re: optimize ...Michael Loftis4 May
    • Re: optimize ...Jimmy Brake4 May
      • Re: optimize ...Michael Loftis5 May
RE: optimize ...Lopez David E-r9374c2 May