The index must be updated with each insert. If you don't need fast
selects then removing the index should help a little. You can also
turn off locking (the default is on) if you don't need to worry about
multiple process access.
--
You received this message because you are subscribed to the
Start a transaction before you do a bunch of inserts. Commit the
transaction when you're done. Otherwise the DB starts/commits a
transaction around each insert. The DB waits for disk activity to
complete on the commit step, so that's the rate-determining step.
On Nov 1, 9:50 pm, Mark Carter
2 matches
Mail list logo