[V4RB] speeding up UPDATE statements

[Ruslan Zasukhin]

on 1/24/03 8:25 AM, WonderFef at wonderfef at noos.fr wrote:

>>> Finally, the workaround was to use a Vcursor.update instead of an UPDATE SQL
>>> statement... Now my loop runs 100s times faster!
>> 
>> Hmm, so the main overhead bring SQL string building and parsing as I see.
> 
> I first thought it was the SQL string building that was the cause of the
> slowness.
> But when I tested the loop without sending the SQLExecute method, it ran
> fast. As soon as I added the SQLExecute in the loop, performances collapsed,
> especially on Windows.
> 
> As a conclusion, I would say that SQL parsing on Windows is slow.

Okay, at least new SQL parser we will make it as optimized as possible.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------