Re: Huge Data

Shridhar Daithankar wrote:

>On Wednesday 14 January 2004 18:22, Matthew Lunnon wrote:
>
>
>>  select logid, agentid, logbody from log where logid=3000000;
>>
>>  this query also returns after about 120 seconds. The table log has about
>>  7 million records, and logid is the primary key of log table. What about
>>  that? Why is it too slow?
>>
>>
>
>How about
>
>select logid, agentid, logbody from log where logid='3000000';
>
>
Oh my god. It is unbelievable. The result is great. Thanks for all guys
who helped me.

-sezai