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 <[email protected]> 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.
