Wasted Space Within Files

Hi everyone. Just a simple query.

Does anyone know of a simple way to determine how much "wasted space" is in 
an sqlite file. As I'm sure we all know, when you delete records, drop a 
table, etc. the data is still there. I'm writing a program in which this 
will happen fairly regularly, and I was wondering if there was a relatively 
easy way to determine how much of a file is "wasted space" with all this 
deleted data. Is it just as simple as adding up the existing data and 
deleting that amount from the actual file size, or is there a better method?

Thanks in advance,

Brady Hutmacher


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Get 128 Bit SSL Encryption!
http://us.click.yahoo.com/CBxunD/vN2EAA/xGHJAA/EbFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
sqlite-unsubscribe-VgYJa0VH1e9BDgjK7y7TUQ@xxxxxxxxxxxxxxxx

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/