On 7/19/07, Mike Orr <[EMAIL PROTECTED]> wrote: > I'm amazed at the speed of mysqldump and its reloading. It packs a > bunch of rows into one INSERT statement. I don't see why that's so > much faster than than executemany but it provides another potential > avenue for speed. I'm not sure if MySQL is the only engine that does > this.
Here's an exhaustive set of timings on the options you have with postgresql: http://www.depesz.com/index.php/2007/07/05/how-to-insert-data-to-database-as-fast-as-possible/ summary: COPY is fastest; that is what pg_dump uses. multi-row inserts in transactions got within a factor of 3. naive single-row inserts were 30x slower than COPY. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---