- 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 query
select
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 query
select * from bla where date like 20021025% order by date DESC limit 20
searhc time is 2,4 to 3,2 seconds
what a hell is going on?
What can I do to fast up these quesry
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
Hi friends,
Can anybody tell me some good projects in C/C++/ with
MYSQL with brief explanation. Focus is on MYSQL.
Thanks in advance.
regards...
-krishna
Email: [EMAIL PROTECTED]
__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http