TIP OF THE DAY!!! : SQL request and speed ? III

[Ruslan Zasukhin]

On 10/30/05 7:38 PM, "Thierry Nauze" <ohmitou at wanadoo.fr> wrote:

>>     query = "INSERT INTO maTable (id,maVarChar) VALUES (:1,'A')"
>> 
>>    for i=1 to 10000
>>        call baseValentina.SqlExecute( query, Array( str(i) ) )
>>    next
>> 
>> Such way is much faster of original way, although still (of course)
>> is not
>> so fast as Api calls. But close enough....
> 
> OK. With bindings, Velentina 2  : 0.53 s
> And, with classic resquest, RealSQL : 0.46 s.

BTW, 

If continue grow number of records (I have test to million once)
Valentina start wins. It seems that was without indexes.

This was always. 
The bigger db and the harder query the more Valentina wins.


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