- Original Message -
From: "svens" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 25, 2002 3:45 AM
Subject: can anybody tell me!!!
> Hello
>
> I have server Intel P-4 2,8Ghz 2Gb RAM
>
> so
> and
> I hve INNODB
> and table with 145000 records
> and when Im trying to
Do you have the date field keyed in the table definition?
I assume you have numbers after the date, or text, otherwise
you should be doing an = without the %...
Really to speed it up you should have a date field you query on,
which is keyed, and whatever is in the record after the date sho