db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Van Couvering <da...@vancouvering.com>
Subject Database storage overhead
Date Fri, 05 Feb 2010 18:26:52 GMT
Say I have a database with 1 million rows, each row has a BLOB column so can
vary in size from about 30bytes to 1MB, but averaging around 1K/row

There are two indexes - one for the primary key and a secondary index for
one integer column.

If I didn't account for overhead, I'd say that this would take up around
1million x 1000 bytes or 1GB + 1 million x 8bytes or 8MB for the secondary
index.

But that's assuming a "perfect" layout for the database.  I am wondering,
how much overhead should I account for?

Thanks!

David

-- 
David W. Van Couvering

http://www.linkedin.com/in/davidvc
http://davidvancouvering.blogspot.com
http://twitter.com/dcouvering

Mime
View raw message