BinaryLink vs ObectPtr

Olivier vidal_olivier at yahoo.fr
Mon Jan 24 14:28:03 CST 2005


Hi Ruslan and list,

In my tests to know the advantages of the binary links on objetPtr, I 
made a small bench.
(in doc, the advantages and Inconvenience of the various ways are not 
explained)

DB with BinaryLink:
SELECT * FROM zipcity join street we linkcitystreet where zipcode = 
'75000'

DB with ObjectPtr:
SELECT * FROM zipcity, street where street.zipcityptr=zipcity.recid and 
zipcode = '75000'
( If I does not put "street.zipcityptr=zipcity.recid", there is a CRASH)

BinaryLink is faster of approximately 10 %. It is little.
When Valentina 2 will be optimized, both ways will approximately be so 
fast or binarylink will be even faster?
Later, to use binaryLink will allow more possibilities?

thank you

olivier



More information about the Valentina-beta mailing list