[ANN] VCOM, VNET, V4MD, Vserver WIN 2.3 b8 -- 500 times faster joins

Ruslan Zasukhin sunshine at public.kherson.ua
Mon Apr 3 10:50:35 CDT 2006


Hi All, 

You can download these Windows products of 2.3 b8 builds.
Mac builds in few minutes later

The MAJOR theme of this build -- super fast joins.

E.g. One bench instead of 15 minutes (1000 seconds)
Now takes only 2.2-1.8 sec    500 times faster.


The new algorithm of join is used only if you have indexes on join-fields.
Easy to see that this is always true for

    * ObjectPtr - links
    * Binary Links

Foreign Key -- depends on your db design. We recommend to have indexes on
KEY and PTR fields always.


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




More information about the Valentina-beta mailing list