[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