Sessions at PHP UK Conference 2010 about Scaling with slides

Your current filters are…

Clear

Unscheduled

  • Database optimisation

    by Remo Biagioni

    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.

Schedule incomplete?

Add a new session

Filter by Day

Filter by coverage

Filter by Topic