[Dbix-class] Help with Titanic Number of Inserts

Oliver Gorwits oliver.gorwits at oucs.ox.ac.uk
Wed Jan 24 09:50:20 GMT 2007


Ryan Richt wrote:
> Anyway, we need to make > 112,000,000 inserts per day.

If you haven't already, try to get some clue applied to your database 
design. Things like having to update indexes can make a huge difference 
to the speed of inserts, depending on how your systems are designed.

An excellent starting point is the book "The Art of SQL":

    http://www.oreilly.com/catalog/artofsql/

regards,
oliver.
-- 
Oliver Gorwits, Network Infrastructure Group,
Oxford University Computing Services



More information about the Dbix-class mailing list