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)
