V4MD: reducing file size

[Ruslan Zasukhin]

On 6/22/04 5:55 PM, "Andrew Sinning" <andrew at learningware.com> wrote:

Hi Andrew,

> I'm trying to figure out how to clean up the garbage in my database.
> 
> After deleting 80% of records, I Flush, Dump, CloseDatabase, and then
> LoadDump, but the size of my database files (notably the .dat file) stay
> the same.
> 
> -- Flush
> dbConn.Flush()
> -- Dump
> dumpFile = dbFile&"_dump.txt"
> dbConn.Dump(dumpFile,2)
> -- close conn
> CloseDatabase(dbConn)
> -- delete existing files
> folder = GetContainingPath(dbFile)
> fileRoot = GetLastPathItem(dbFile)
> baDeleteXFiles(folder, fileRoot&".*" )
> -- create new
> dbConn.LoadDump(dumpFile,dbFile,2)
> -- connect
> dbConn.OpenDatabase(dbFile)
> 
> I have confirmed that I am actually deleting the existing files before
> the LoadDump.
> 
> The size of the dumpFile is 1.6Mb, but the size of the .dat file is
> 4.7Mb.
> 
> What am I doing wrong?

XML Load -> remove ANY garbage.

If you have not many data, just 1.6MB
But db you get bigger,

Then you can make it smaller if you set db.segment size not 32KB
But 16 or 8KB


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------