Re: Wasted Space Within Files

Brady Hutmacher (AKA Capt. Hack'em) wrote:
> 
> Does anyone know of a simple way to determine how much "wasted space" is in 
> an sqlite file. 
 >

I wrote a short TCL script to compute this for you.
This script must be run using the "testfixture"
executable that is build when you type "make test".
The "textfixture" executable has some bindings to
internal APIs that are not normally published, and
these internal APIs are needed in order to compute
the information you desire.

The TCL script is named "space_used.tcl" and has just
been checked into the CVS repository.  You can download
a copy from:

   http://cvs.hwaci.com:2080/sqlite/getfile?f=sqlite/tool/space_used.tcl&v=1.1


-- 
D. Richard Hipp -- drh-X1OJI8nnyKUAvxtiuMwx3w@xxxxxxxxxxxxxxxx -- 704.948.4565


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/