2000-11-03 18:41:05+01 by Dan Lyke 0 comments
Holy Cats! I just discovered how expensive autocommit in PostgreSQL is. Updating data in 1,800 records from an XML file I'm seeing a full factor of 100 from autocommits versus putting all those updates in a single transaction. Youch. This explains a lot. Wonder if there's a good way to say "these updates aren't transaction critical, do them optimally" so that I don't end up choking memory on huge updates?
[ related topics: Interactive Drama Web development Content Management ]
comments in ascending chronological order (reverse):
We will not edit your comments. However, we may delete your comments, or cause them to be hidden behind another link, if we feel they detract from the conversation. Commercial plugs are fine, if they are relevant to the conversation, and if you don't try to pretend to be a consumer. Annoying endorsements will be deleted if you're lucky, if you're not a whole bunch of people smarter and more articulate than you will ridicule you, and we will leave such ridicule in place.
Flutterby™ is a trademark claimed by
Dan Lyke for the web publications at www.flutterby.com and www.flutterby.net.