> Hi list, > > I'm trying to optimise a SELECT ... LIMIT query, perhaps i miss something > important and so, i'm asking your help :) > > I'm using MySQL 4.0.15 under Linux. > > Here's a test query : > mysql> explain SELECT * FROM F4000 WHERE ReplyTo=8711465 ORDER BY Numero > LIMIT 234599,20; > +-------+------+----------------+----------------+---------+-------+-------- > +-------------+ > | table | type | possible_keys | key | key_len | ref | rows > | Extra | > +-------+------+----------------+----------------+---------+-------+-------- > +-------------+ > | F4000 | ref | ReplyTo_Numero | ReplyTo_Numero | 4 | const | 188063 > | Using where | > +-------+------+----------------+----------------+---------+-------+-------- > +-------------+ > > And here's index description : > mysql> show index from F4000; > | F4000 | 0 | PRIMARY | 1 | Numero | A > | 2535091 | NULL | NULL | | BTREE > | F4000 | 1 | ReplyTo_Numero | 1 | ReplyTo | A > | NULL | NULL | NULL | | BTREE > | F4000 | 1 | ReplyTo_Numero | 2 | Numero | A > | NULL | NULL | NULL | | BTREE > > ReplyTo and Numero are both integer. > > This query took around 1 sec, could i made something to have better > performance ? > > PS : I know that Richard Davey have post a question on limit, 2 two days > ago, but i didn't find anything that can help me. > I also look at http://www.mysql.com/doc/en/LIMIT_optimisation.html without > any success. > > Thanks. > David > Any Idea ?
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
