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