Re: Speed up single INSERT INTO statement?

2012-05-14 Thread TXVanguard
g 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 tr

Re: Speed up single INSERT INTO statement?

2012-05-09 Thread Peter Ondruška
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. > >

Re: Speed up single INSERT INTO statement?

2012-05-09 Thread Nathan Boy
hing 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--tp33763645p33

Re: Speed up single INSERT INTO statement?

2012-05-09 Thread Libor Jelinek
ld 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. > >

Speed up single INSERT INTO statement?

2012-05-09 Thread TXVanguard
://old.nabble.com/Speed-up-single-INSERT-INTO-statement--tp33763645p33763645.html Sent from the Apache Derby Users mailing list archive at Nabble.com.