Re: Which strategy is better to traverse a big table?
Posted by:
aftab khan
Date: February 23, 2009 07:04AM
if your table is static then you may sort the table records using ALTER TABLE ... ORDER BY ....
and simply run this sql SELECT * FROM feedback as many time as you want, because the records are physicaly sorted. if the table is not static then it's better to limit the query result
>Which way is faster to go through a big table?
in any case mysql has to sort all rows but using LIMIT you actually constrain the number of rows returned by the SELECT statement.
Subject
Views
Written By
Posted
4509
February 23, 2009 01:58AM
Re: Which strategy is better to traverse a big table?
2018
February 23, 2009 07:04AM
1847
February 24, 2009 11:29AM
1908
February 25, 2009 02:25PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.