[V4RB] speeding up UPDATE statements

[Ruslan Zasukhin]

on 1/23/03 8:03 PM, Wonder Fef at wonderfef at noos.fr wrote:

>>>> 1) myField1  -- is string field and you do replace of string ?
>>>> 
>>>> 2) am I right that you do this query for different myID ?
>>> 
>>> 1) = YES (field is of type string(256))
>>> 2) = YES (this field is also a string(256))
>> 
>> String(256)  ???
>> 
>> This is not good choice.
>> Use VarChar 256 then.
> 
> I used varchar(30) for the Field 'ID', which speeded up a little more my
> UPDATE statements, but this was not enough.
> 
> 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.

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