db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Noll" <dan...@nuix.com>
Subject Re: Large multi-record insert performance
Date Sun, 18 Mar 2007 22:11:06 GMT
Derek said:
> Thank you for sharing your finding.  It is interesting to see that using
> executeBatch was actually slower than executeUpdate.

I'm not confident enough to say whether this is really the case as the 
margin of error is greater than the difference in speed.  I would have to 
run the same test a few thousand times and take an average, before telling 
whether batching is really slower or faster.

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.


Mime
View raw message