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