On Tue, Dec 17, 2002 at 07:37:17AM +0700, Mpu Gondrong wrote: > Hello mysql, > > I am currently building news portal with php and mysql, and quite > surprised knowing mysql doesn't support descending index. Why ? I > think this feature is really needed. For example I want to show the > latest news (from last updates, not always everyday). With ascending > index, mysql doesn't use it. > > My current trick is crawling back (ie 1 month) and forward (if any in > that month), but this is really annoying. Any plan / trick for this ? > TIA.
I'm not quite sure what you're after, but MySQL 4.0 has support for reading indexes in reverse order in some circumstances. This greatly speeds up some queries that were slow in 3.23. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 1 days, processed 66,924,046 queries (426/sec. avg) --------------------------------------------------------------------- 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