Java Big Database Inserts

Question

I have a database in which I need to insert a batch of data (about 500 thousand records at a time). I tested the derby and saw the insertion time of about 10-15 minutes for these many entries (I did batch insertion in Java).

Does this time seem to be slow (working on an average laptop)? And are there any ways to accelerate it?

thank,

Jeff

Answer 1

This time it seems quite reasonable and is consistent with the cases that I have observed. If you want it to work faster, you need to use the bulk insert option and disable the security features:

• PreparedStatements 5000 10 000 , .
• .

EDIT: /, .

5400 /. 5 . , ( ), 40 (500000 * 5 ). , , .

() , , ; , , -. , .

Answer 2

? .