db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Øystein Grøvlen <Oystein.Grov...@Sun.COM>
Subject Re: Large multi-record insert performance
Date Wed, 14 Mar 2007 19:47:14 GMT
Sedillo, Derek (Mission Systems) wrote:

> Iterate an array of 1000 records and create a VALUES clause string to 
> look like:
> /String records = "(1,1,1), (2,2,2), (3,3,3), (4,4,4), …(1000, 1000, 
> 1000)";/

You might already know, but make sure to use a StringBuffer when you are 
doing this so you avoid creating a new String object for every triplet 
you append.

--
Øystein

Mime
View raw message