Where did the legendary speed of Valentina remain?
Ralf Sander
ralf at end-if.de
Mon Apr 4 12:06:32 CDT 2005
Hi Ruslan,
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?
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
Cheers,
Ralf
More information about the Valentina
mailing list