Tag Archives: order

Scalable MySQL: Avoid offset for large tables

It’s fairly common to need to iterate through all the rows in a given table and perform an action on each. The usual way to do this is fetch rows from the database in batches using LIMIT, specifying an offset … Continue reading

Posted in High Scalability, MySQL | Tagged , , , , , , , , | 8 Comments