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