Darryl Ross wrote: > Make sure you put any inserts into a transaction. Using a disk based > database, inserting 10,000 rows went from being a multi-minute operation > to a split-second operation, just by putting them inside a BEGIN/COMMIT.
This applies to a lot of databases (I'm thinking of Postgres and Oracle in particular) - INSERTs outside of a transaction are wrapped in their own individual transactions, instead of around a block of 'em. I think there's an option to later Postgres' to switch it off on a per-session basis, at least from psql. -- Regards, Daryl Tester, IOCANE Pty. Ltd. _______________________________________________ sapug mailing list [email protected] http://mail.python.org/mailman/listinfo/sapug
