SQL request and speed ? III

Thierry Nauze ohmitou at wanadoo.fr
Sun Oct 30 15:09:52 CST 2005


Hello Ruslan,

For a rudimentary request :

   for i=1 to 10000
     call baseValentina.SqlExecute( "INSERT INTO maTable  
(id,maVarChar) VALUES ("+str(i)+",'A')" )
   next


RealSQL is always 8 (even 10) time faster than Valentina 2.11  :   
0.45 s  vs 4.87 s !

I had sent you an example of program before the exit of the version  
2.05...
Nothing changed !

Is it necessary to avoid the use of the SQL with Valentina 2 ?

Regards,

--
Thierry NAUZE        Saint-Denis de la Réunion




More information about the Valentina mailing list