Hi!
Mon, 20 May 2002 21:30:52 +0900, tu as dit : > Hi, You are look like very tired... > I have a good idea!!! > See fellowing line. "alter table TABLE_NAME add index (timestamp > desc);" > import point is "index(timestamp desc)". you did not set index of > timestamp, so your query has been slow.... > You can your query fast by adding index timestamp and you must add > 'desc' after 'timestamp' .... > The reason to add 'desc' is that index of timestamp is ordered > automatically and rebuilded index structure when table is inserted some > data... > So... Complete script is "alter table TABLE_NAME add index (timestamp > desc); "; I have just tried this, but it still takes 1.5sec to run the select... :-( -- Fabien Penso <[EMAIL PROTECTED]> | LinuxFr a toujours besoin de : http://perso.LinuxFr.org/penso/ | http://linuxFr.org/dons/ --------------------------------------------------------------------- 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
