[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