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

Reply via email to