[V4RB] speeding up UPDATE statements

[Ruslan Zasukhin]

on 1/23/03 4:58 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.


> The only time I had speed problem with Valentina was the bad choices type I
> made for my fields...


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