Kristian said:
How often did you issue a commit in this test?
(and was auto-commit enabled or disabled)
As my original message stated, it did each insert in a different
transaction.
i.e. one commit per insert.
The latter tests just did the commit once after all the inserts were done.
We actually contain this all automatically, we have a utility method which
we call and pass a callback to, which handles the transaction for us so that
we don't need to do commit/rollback everywhere. (The method also handles
retries if something bad happens.)
Daniel Noll
Nuix Pty Ltd
Suite 79, 89 Jones St, Ultimo NSW 2007, Australia Ph: +61 2 9280 0699
Web: http://nuix.com/ Fax: +61 2 9212 6902
This message is intended only for the named recipient. If you are not
the intended recipient you are notified that disclosing, copying,
distributing or taking any action in reliance on the contents of this
message or attachment is strictly prohibited.
