Adam B wrote on 01.05.2009 19:50:
> I realize that I could set a save-point before every INSERT but that
> nearly doubles the processing time.
That's interesting.
I did a quick test with JDBC inserting 500,000 rows and the time when using a
savepoint for each INSERT was not really different to the one when not using a
savepoint (less than a second which could well be caused by other things in the
system).
I tested this locally so no real network traffic involved, which might change
the timing as more stuff is sent over to the server when using the savepoint.
Thomas