[V4RB] speeding up UPDATE statements
Wonder Fef
wonderfef at noos.fr
Thu Jan 23 19:03:30 CST 2003
>>> 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!
Thank you
Eric
More information about the Valentina
mailing list