Re: can anybody tell me!!!

2002-10-25 Thread Mark
- 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

Re: can anybody tell me!!!

2002-10-24 Thread Anthony R. J. Ball
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