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