Where did the legendary speed of Valentina remain?

[Ruslan Zasukhin]

On 4/4/05 1:06 PM, "Ralf Sander" <ralf at end-if.de> wrote:

Hi Ralf,
 
> I did some quick tests with your sql example "Single Table" in version
> 1.1 and the new version 2. And I really can't believe the results.
> Almost 10 times slower? Is there something wrong in my tests or did
> Valentina go the way of almost every new application?

You mean 
        Examples / 1_x_Examples / (1) Single Table

Do not worry, we will return back all speed :-)

Just for now we work on correctness.
We have NOT spend yet almost any time to optimize what we have.

And the main is that all new mechanisms that we have built potentially are
much faster. Of 1.x

By the way. It needs yet look what this example do.
    Important point is that 2.0 DO NOT index fields on search,
    only on sort yet.

So, if that example do not set flag fIndexed for fields,
Then v2 do non-indexed searches (which 1.x cannot do at all btw).

You can check this self. And it looks to be true. You do NON-indexed
searches for 2.0. Because time of first and second run are comparable.


> Here are the results:
> 100.000 Records:
> 
> query / first and second call v1  / first and second call v2 /result
> select * from Person where byte_fld=100  0.014 - 0.009   /   0.5 - 0.2
> --> ca 374 records
> select * from Person where byte_fld >100   0.05 - 0.08   /   0.5 - 0.2
> --> ca 58000  records
> select * from Person where string_fld='line 101'  0.03- 0.01   /   0.3
> - 0.3  --> 1 record 
> 
> 200.000 Records
> 
> select * from Person where byte_fld=100  0.01 - 0.01   /   0.4 - 0.4
> --> ca 758 records
> select * from Person where byte_fld >100   0.09 - 0.16   /   0.8 - 1.16
>   --> ca 116000  records
> select * from Person where string_fld='line 101'  0.08- 0.01   /   0.95
> - 0.61  --> 2 records 

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