Where did the legendary speed of Valentina remain?

[Ralf Sander]

Hi Ruslan,

Puh, it took a load of my mind. :-)
I am acustomedc to be pained with decreased speed of new app versions, 
but did't expect it from Valentina. And it looks like I was right.

You are right, the fields are not indexed. With index on, I get 
aproximately old values.
For an unindex search, the results were quite fast, I think.

Cheers,
Ralf

> 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]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>