Strange indeed. Perhaps there's some background stuff happening that
messes with the results (auto VACUUM?).
In my mind, however, it makes sense that it would take longer: 2 extra
operations against the server (save&release).
Thomas Kellerer wrote:
Adam B
wrote on 01.05.2009 22:59:
Perhaps I'm doing something wrong. I'm
consistently taking over 20s for the following test case. (Without
savepoints it takes under 10s)
That's really strange. I can reproduce your results on my computer (25
vs. 65 seconds).
When running my import program against your table, I don't see a big
difference between the savepoint solution and the one without (I added
a row to the import file that would fail to make sure I was really
using savepoints)
My import program is doing more or less the same thing as your code, so
I have
no idea what's going on here.
There was one strange thing though: I had one run where it took a lot
longer with the savepoint than without. But I could not reproduce that,
all other tests where approx. the same runtime with or without
savepoints.
Very strange.
Might be worth posting to the JDBC list, to see if this is a driver
issue....
Thomas
Videx Inc. 1105 N. E. Circle Blvd. Corvallis OR 97330 (541) 758-0521
CONFIDENTIAL COMMUNICATION: The email message and any attachments are intended only for the addressee. They may be privileged, confidential, and protected from disclosure. If you are not the intended recipient, any dissemination, distribution, or copying is expressly prohibited. If you received this email message in error, please notify the sender immediately by replying to this e-mail message or by telephone