db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Libor Jelinek <ljeli...@virtage.com>
Subject Re: Speed up single INSERT INTO statement?
Date Wed, 09 May 2012 18:03:40 GMT
Sorry Brett, I'm not responding to your question but enganged by your
"Would it be helpful to
temporarily turn off constraints for the table?"

AFAIK it's not possible to do this. Was it a question or you know how to do
it? If so, point me out, please.

Cheers,
Libor

On Wed, May 9, 2012 at 7:00 PM, 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