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
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.
>
>
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
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.
>
>
://old.nabble.com/Speed-up-single-INSERT-INTO-statement--tp33763645p33763645.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.