List:General Discussion« Previous MessageNext Message »
From:Oscar Date:December 22 2009 5:02am
Subject:ORDER BY favours full scan over a faster filesort
View as plain text  
hi all,

it said the bug  has been fixed in 5.1.25.

# Query_time: 1.657438  Lock_time: 0.000085 Rows_sent: 40  Rows_examined: 885756
SET timestamp=1261447735;
select as id163_, item0_.add_time as add2_163_ from item
item0_ where item0_.role_id=2556 order by desc;

mysql version: 5.1.34

have you guys met this problem?


ORDER BY favours full scan over a faster filesortOscar22 Dec