Table structure?

[Ruslan Zasukhin]

On 4/30/06 4:02 PM, "Joakim Schramm" <joakim at astrocalc.com> wrote:

>> In below code I see only VarChars with 1022 length
>> 
> This code is now somewhat old as I have done changes so no more VarChar 1022

You mean that you have convert all VarChar to Strings ???
This is also not good idea!

For strings that can vary, and which can be with length > lets say 10 bytes,
VarChars can be more effective of strings.

    String[20] - okay still can be

    String[60] ? Hmm. In 90% NO

    String[100] -- most probably no. VarChar better


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]