I don't know of a way to turn off constraints. I was referring to the use of
the "ALTER TABLE
DROP CONSTRAINT " command.
> 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
> it? If so, point me out, please.
> On Wed, May 9, 2012 at 7:00 PM, TXVanguard 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
>> for the table, and a few other things, but nothing seems to affect the
>> 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:
>> 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.