SQL request and speed ?

[Ruslan Zasukhin]

On 8/16/05 6:20 PM, "Claudius Sailer" <Claudius at sailer-online.de> wrote:

> but question still stand, why is Valentina 2 so much slower as
> Valentina 1.

I think it is NOT so much slower.

Can be affect of changes in behavior, which developers do not realize.

* for example in v2 if you set flag fUnique or fIndexByWords,
    this DO NOT means that field already indexed.

    so such code will do non-indexed search

* OR Valentina 2 do not create index on non-indexed field as did v1.
    instead it just do non-indexed search


> I knew from an older Version of new RealSQL, that SQL is much more
> simple as Valentina SQL, but this doesn't help with speed differences
> between V1 and V2.


> #641 shows differences in V1 to V2 too.
> With this performance I can't tell my users to move from V4RB1 to V4RB2.

Actually it seems Frank, have told that for him v2 do searches FASTER than
v1 did ...



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