Compact and Defragment

[Ruslan Zasukhin]

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]