Strange indeed. Perhaps there's some background stuff happening that messes with the results (auto VACUUM?).<br /><br
/>In my mind, however, it makes sense that it would take longer: 2 extra operations against the server
(save&release).<br/><br /> Thomas Kellerer wrote: <blockquote cite="mid:gtfs47$9j3$1@ger.gmane.org"
type="cite">AdamB wrote on 01.05.2009 22:59: <br /><blockquote type="cite">Perhaps I'm doing something wrong. I'm
consistentlytaking over 20s for the following test case. (Without savepoints it takes under 10s) <br /><br
/></blockquote><br/> That's really strange. I can reproduce your results on my computer (25 vs. 65 seconds). <br /><br
/>When running my import program against your table, I don't see a big difference between the savepoint solution and
theone without (I added a row to the import file that would fail to make sure I was really using savepoints) <br /><br
/>My import program is doing more or less the same thing as your code, so I have <br /> no idea what's going on here.
<br/><br /> 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. <br
/><br/> Very strange. <br /><br /> Might be worth posting to the JDBC list, to see if this is a driver issue.... <br
/><br/> Thomas <br /><br /><br /></blockquote><br /><br /><br /><hr />
Videx Inc. 1105 N. E. Circle Blvd. Corvallis OR 97330 (541) 758-0521<br/>
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<br
/>