V4MD: reducing file size

Andrew Sinning andrew at learningware.com
Tue Jun 22 11:20:17 CDT 2004


>>Then you can make it smaller if you set db.segment size not 32KB

How do I do that with a LoadDump() ?

I see that for CreateDatabase, there is a segmentSize param:

  CreateDatabase object me, string path, [integer Mode], [integer
SizeOfCluster]

But for LoadDump, there is no such param:

  LoadDump object me, string pathDumpFile, string pathNewDb, integer
inKind




Thanks.

-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net]On Behalf Of Ruslan
Zasukhin
Sent: Tuesday, June 22, 2004 10:40 AM
To: valentina at lists.macserve.net
Subject: Re: V4MD: reducing file size


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
-------------------------------------------------------------

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina




More information about the Valentina mailing list