• Post Reply Bookmark Topic Watch Topic
  • New Topic

Derby Database Bulk Insert

Alvaro Quintana
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,

What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!