•  

Database optimisation

A session at PHP UK Conference 2010

A real life example getting more throughput with fewer queries.

Over the last year we've grown a database from a few hundred megabytes to just over one terabyte. The database is reported on and populated by a network of servers using PHP. As the database has grown we've had to look again our initial assumptions and ways of working. One table has over 2billion rows; 2.5 million rows every day are added to another table. This talk will cover how we use explain, foreign keys, normalising data without sacrificing performance, queuing and using memcache. And, how we've made the system run faster now than it did with a much smaller database.

About the speaker

This person is speaking at this event.
Remo Biagioni

Coverage of this session

Sign in to add slides, notes or videos to this session

PHP UK Conference 2010

England England, London

25th26th February 2010

Tell your friends!

Short URL

lanyrd.com/sxcd

Official event site

www.phpconference.co.uk/2010

View the schedule

Share

Topics

See something wrong?

Report an issue with this session