How can RecID etc. not use disk space? // New comment from ruslan

[Ruslan Zasukhin]

On 4/1/09 9:21 PM, "Simon White" <simonwhite at dciphercomputing.com> wrote:

Hi Simon,

Almost true, but not exactly.

If you have say 10 records,
Then delete 6 7 8 9 records, then you have
    
    Vtable.Records is 6
    Vtable.PhysicalRecords is 10   -- right

But if you delete now 10 record, you will get table with 5 records only.
Size will be reduced.

    Vtable.Records is 5
    Vtable.PhysicalRecords is 5


Also if you have holes in table and ADD new record, then it will go into
free space, i.e. Into 6th record for above example.


> Hi
>  
> In that case I interpret this to mean that the table can never shrink in size
> even if data is deleted otherwise the record would be moved.

> Regards,
> Simon White
> dCipher Computing
> 705-721-3382
> simonwhite at dciphercomputing.com
> 
>> Hi Simon,<br />
>> <br />
>> well, this is very good explained in few places in Valentina
>> WIKI.<br /> have you read that? Even pictures present.<br /> <br />
>> KEY WORDS to understanding are:<br /> - each record has fixed
>> place<br /> - record never is moved<br /> - records have fixed size
>> effectively<br /> <br />
>> all these together allow to use  NUMBER of record as its RecID. <br
>> /> <br /> <br />
>> 
>> --
>> A new comment has been added by ruslan on Paradigma Software -
>> Valentina Database.
>> 
>> To view this comment, click here: http://www.valentina-
>> db.com/index.php?option=com_billets&controller=ticket&task=view&id=5
>> 
>> You may be required to login to your account.

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