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 should be in a separate field... On Fri, Oct 25, 2002 at 04:45:00AM +0300, svens wrote: > 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 requests ?? > > I cant imagine if my table will contain some of 960000 rows > it will search my query a hundred years > > > is it some way to get resuls faster -- much more fuster ?? > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > -- ___ __ __ __ _ _ ____ _ _ ____ ____ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__) ) ( )__) )( (___/(______)(__)(__)\/ (____)()(_)\_)(____) (__) The trouble with reality is, there's no background music. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php