After a long battle with technology, [EMAIL PROTECTED] (Richard Huxton), an earthling, wrote:
5. You might want to batch together queries into transactions of a few hundred or even few thousand updates.
When this particular application got discussed on local LUG mailing list, this emerged as being one of the factors most likely to be a Big Deal.
Yep, except... Madison said a laptop was involved, so I'm guessing it's an IDE drive lying about sync-ing. If fsync is effectively off that shouldn't have such a huge effect should it?
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings