Tag Archives: performance

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

PEAR Cache_Lite – preventing stampeding

The PEAR Cache_Lite package is an excellent caching system; lightweight and fast, however when put into use on a high-traffic website a few issues came to light. The first problem we hit was stampeding. What’s stampeding? Stampeding is the situation … Continue reading

Posted in PHP | Tagged , , , , , , , | 3 Comments