Consider batching inserts and use larger log file. On 9 May 2012 19:01, "TXVanguard" <brett.den...@lmco.com> wrote:
> > I need to speed up a single INSERT statement in Derby. > > The statement has the form: > > INSERT INTO table (col1, col2) SELECT a, b FROM .... > > In my application, it take about 10 seconds to insert 3000 records. > > I have experimented with turning off autocommit, adjusting > derby.storage.pageCacheSize and derby.storage.pageSize, turning off indexes > for the table, and a few other things, but nothing seems to affect the > speed > of the INSERT. > > Are there any other techniques I can try? Would it be helpful to > temporarily turn off constraints for the table? > -- > View this message in context: > http://old.nabble.com/Speed-up-single-INSERT-INTO-statement--tp33763645p33763645.html > Sent from the Apache Derby Users mailing list archive at Nabble.com. > >
