[FAQ] Valentina Question

[Sims, John]

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of 
> Ruslan Zasukhin
> Sent: Friday, June 10, 2005 2:06 PM
> To: Simon White; valentina at lists.macserve.net
> Subject: Re: [FAQ] Valentina Question
> 
> 
> 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

Hi Ruslan,

For any given record, does the OID value remain constant even after other records are deleted/added to the database (as RecID does)?

Thanks,

-John