Performance
Memcache Statistics
by Steven Brown on May.31, 2010, under Performance
I needed to work with Memcache again today and remembered this awesome tool:
Zend Framework Performance Architecture Part 3: Denormalising Data
by Steven Brown on Jun.12, 2009, under Performance, PHP, Zend Framework
If you’re not already indexing your databases, head on over to http://hackmysql.com/documents and read everything there.
If you’re really looking to squeeze every last drop of performance out of your database then you can denormalise your data where otherwise you would need a join. (continue reading…)
Zend Framework Performance Architecture Part 2: Multiple Row Caching
by Steven Brown on Jun.10, 2009, under Performance, PHP, Zend Framework
In the last article I covered how to precache individual rows from a database in order to improve the performance of your application. While this is certainly useful for instances where we need just a single row, a lot of our queries are to retrieve multiple rows from the database. One of the problems with caching results from these queries is that if a single row’s details change, we need to scrap the entire cache and start again, otherwise we might display outdated information. This applies not only to the fields we are using in the query, but also fields we display to the user. (continue reading…)
Zend Framework Performance Architecture Part 1: Row Precaching
by Steven Brown on Jun.09, 2009, under Performance, PHP, Zend Framework
One quick and easy way to take a chunk out of your database usage is to precache data. When this is done effectively you can actually serve up many requests without even connecting to the database at all. One of the simplest implementations I have found involves precaching rows when they are created or updated. Essentially when the data changes you store the changed data in cache so when it is requested it can be loaded from a file instead of the database. We do this because database access is very slow compared to file access. (continue reading…)
