db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From TXVanguard <brett.den...@lmco.com>
Subject Re: Speed up single INSERT INTO statement?
Date Mon, 14 May 2012 14:31:12 GMT

I don't know of a way to turn off constraints.  I was referring to the use of
the "ALTER TABLE <table> DROP CONSTRAINT <constraint>" command.


liborjelinek wrote:
> 
> 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.
>>
>>
> 
> 

-- 
View this message in context: http://old.nabble.com/Speed-up-single-INSERT-INTO-statement--tp33763645p33830827.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message