Can anyone help ? I have a derby database with one table. The table includes the primary key plus 7 other columns. There is an index on 4 of those 7 columns.
I am inserting 100,049 rows into the table and no-matter what I try, I need more than 32MB to insert those records (at one time). I have tried turning autocommit on and off, I have tried using Batch processing and normal insert processing but whatever I do, I need more than 32MB to insert the 100,049 rows into the table at one time . When using java -Xmx48m to insert the 100,049 rows, free space is around 12 to 14 MB during the insert process. I am trying to understand why the derby database management system needs approx 36MB to insert the 100,049 rows. The database is around 67.8MB in size, when all rows have been inserted. What does derby keep in memory which requires approx 36MB during the entire insert process? Any help will be most appreciated. Regards Trevor Simpson
