db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Ondruška <peter.ondruska+de...@kaibo.eu>
Subject Re: Speed up single INSERT INTO statement?
Date Wed, 09 May 2012 18:30:18 GMT
Consider batching inserts and use larger log file.
On 9 May 2012 19:01, "TXVanguard" <brett.denner@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.
>
>

Mime
View raw message