Hi,
I have a Derby database with two records, the first has 5000 records (of
int, double, double, double, double - so approx 34 bytes per record), the
second has 1000 records (of int, varchar(10), varchar(40) - so approx 102
bytes per record).
5000 * 34 = 166k
1000 * 102 = 100k
Total = 266k (if it was in a text file)
What I don't understand is why the database (seg0 folder) is 1.2MB?
I have compacted the database using;
call SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE('APP', 'mapObject', 1, 1, 1);
call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', 'MAPOBJECT', 1);
Any thoughts please?
Anthony
--
View this message in context:
http://old.nabble.com/Database-size-larger-than-expected-tp32699233p32699233.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
