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:

>> Answer is: use bindings!!!
> 
> So, if I understand well , it is better to avoid classic requests SQL
> with Valentina 2.

Up to you.

If in SOME places you need more speed, you can spend more time to achieve
that.
 

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

So much better, right?

And if you again remember that we use UTF16 and true algorithms that take
into account locales and so on.. Not bad.


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