Compact and Defragment

[Alex Lindsay]

Ruslan,

Thank you for your quick response.

Alex Lindsay

On Sep 7, 2005, at 1:15 AM, Ruslan Zasukhin wrote:

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