Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Derby Database Bulk Insert

 
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic