[FAQ] Valentina Question

[Ruslan Zasukhin]

On 6/10/05 5:31 PM, "Simon White" <SimonWhite at dciphercomputing.com> wrote:

Hi Simon,

> Hi Ruslan
>  
> I have been reading the Valentina documentation and have been wondering what
> is meant by the following statement in regard to RecID and OID
>  
> "The beauty of this field is that its values are not stored on the HDD."
  
> If the item is not stored on the HDD then it does not exist.  If it is
> calculated then the data used to do the calculations must be on the HDD
> somewhere.  So can you clarify what is actually done here?

There is no items on disk :)

There is no data for calculation on disk :))

They work as physical address of a record.
I.e. As offset from file start.

Actually this is very cool.
E.g. Oracle, OpenBase, .. Use _rowid field.
But this is realy ulong field on disk.

If you have 

    1  million records in T      this is 4MB
    10 million records in T      this is 40MB

Each OO DBMS that support ODMG must have 8 byytes OID field.
Again they do it as field on disk. so

    1  million records in T      this is 8MB
    10 million records in T      this is 80MB

Also most probably these fields do have index, so this is another file with
size 1.5-2 bigger.

Each Valentina Table have BOTH these fields, and use ZERO disk space.
As well as zero cache/RAM space to provides the same functionality.


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