Table structure?

[Ruslan Zasukhin]

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

>> 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
>> 
> I have only changed the maxsize of VarChar to smaller values, but most of
> them will go as I remove the keys. I have some of these now as 4 char
> strings.

Deal is that maxsize of VarChar DO NOT make smaller db.
IT is just logical limit which work on INSERT
 
> I know try to find out how I can iterate a BitSet returned from FindValue -
> but I guess it's somewere in the manual, so am looking for it.

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