db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Suresh Thalamati <suresh.thalam...@gmail.com>
Subject Re: Increased disk space allocation when populating database with multiple connections
Date Fri, 09 Feb 2007 20:18:18 GMT
Kristian Waagan wrote:
> Hello,
> 
> For a database population program I run, I have observed that the disk 
> space allocation is larger when populating the database with multiple 
> concurrent connections.
> For a specific configuration, the database ends up at 642 MB with a 
> single connection, whereas it ends up at 1.3 GB when using multiple 
> connections. The raw data volume is at about 215 MB, there are 20 tables 
> and between 20 and 30 indexes (didn't take the time to figure out which 
> indexes are composite, 'show indexes' doesn't give this information but 
> returns 31 rows).
> 
> Is this to be expected?


No. The Difference in size seems to be too high with just inserts. 
Are you doing inserts into the same table in parallel threads ?. Is it 
one particular tables/index that is becoming too big or all the 
tables/indexes ?


Thanks
-suresh



Mime
View raw message