• Post Reply Bookmark Topic Watch Topic
  • New Topic

Derby Database Bulk Insert  RSS feed

 
Alvaro Quintana
Greenhorn
Posts: 10
Fedora Java Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all, I'm new in this forum, but i've been using Java for a few years. Right now i'm developing an application that use an embebed Derby Database (if you see there is another database that fix better to the problem i describe below, i will be glad to check your sugestions), i need to insert in a table 15 million of rows, but these rows are inserted using an statement like this (INSERT (SELECT))... so right now i have threads fetching the database (1000 rows each) and inserting the data, but when database grows this process gets slower. I must tell, that the table does not have any index or constraints. Is there any validation the database is performing that i'm leaving out and is making heavier this process??

Thanks for the help,

Alvaro
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!