hi all, it said the bug has been fixed in 5.1.25. See http://bugs.mysql.com/bug.php?id=35844
# Query_time: 1.657438 Lock_time: 0.000085 Rows_sent: 40 Rows_examined: 885756 SET timestamp=1261447735; select item0_.id as id163_, item0_.add_time as add2_163_ from item item0_ where item0_.role_id=2556 order by item0_.id desc; mysql version: 5.1.34 have you guys met this problem? thanks, -Oscar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
