benchmark

[Ruslan Zasukhin]

On 12/11/06 9:29 PM, "Joakim Schramm" <joakim at astrocalc.com> wrote:

>> For 1:M  binary link in ideal are comparable to ObjectPtr.
>>     right now can be even worse.
>> 
> I use ObjectPtr this way:
> Dim ArrSet As VArraySet
> 
> 
> Set ArrSet = fPtrGroup.FindValue(GroupToDelete) <- ObjectPtr declared as
> VField
> 
> If Not ArrSet Is Nothing Then
>     tCharts.DeleteAllRecords ArrSet
> End If
> 
> Or is there other better way?

This is okay.
 
> No point in using binlinks here then? Can you give an example on when
> binarylink can be better 1:M, ideal with future (planned) improvement in
> mind?

Binary links will not win ObjectPtr technically or by speed for 1 : M.

They can only looks better from point of view design, because tables are
clean without "link"-garbage fields.

 
>> For M:M binary links will win 100%
>> 
> I don't have M:M, could have had use for it in my "big" database but it made
> it expand to 200MB+ instead of the 38MB now using ObjectPtr and some "trix".

So use ObjectPtr fields for now and do not worry :)

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