Compact and Defragment

[Damon Pillinger]

Hi Ruslan,

If I am using RB Valentina 2.05 what would be the SQL command to compact
and defragment a database or table.

Thanks

Best Regards

Damon L. Pillinger
Jensen 2005 by Daisychain
www.daisychain.no-ip.biz
Phone : 03 9532 1220
Fax : 03 9532 1280


-----Original Message-----
From: valentina-bounces+daisychain=iinet.net.au at lists.macserve.net
[mailto:valentina-bounces+daisychain=iinet.net.au at lists.macserve.net] On
Behalf Of Ruslan Zasukhin
Sent: Wednesday, 7 September 2005 4:15 PM
To: valentina at lists.macserve.net
Subject: Re: Compact and Defragment

On 9/7/05 7:35 AM, "Alex Lindsay" <alindsay at mac.com> wrote:

> What is the preferable method for compacting a database after a large
> deletion operation in Valentina 1.11.  This deletion operation will be
> deleting a large percentage of the data in the database.  Do the
> Compact and Defragment SQL keywords work properly in Valentina 1.11?

Yes they work. You need

    Compact then
    Defragment

> Is it preferable to use a Dump and Load approach instead.

Dump and load produce even more compact db because it deleete EACH
deleted
record.

COMPACT delete only free segments of database.
 
> I have noticed reference to Valentina 1.12 but it does not appear on
> the website.  Is 1.11 still the latest of 1.x versions?

1.12 this is special upgrade for C++
 
> I have been waiting for both Realbasic 2005 and Valentina 2 to become
> stable enough to begin porting my application.  It seems that they are
> at this stage now.  Anyone else holding off this migration because of
> known bugs or current limitations?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]


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