Table structure?

Joakim Schramm joakim at astrocalc.com
Sun Apr 30 15:58:42 CDT 2006


 

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of 
> Ruslan Zasukhin
> Sent: 30 April 2006 15:54
> To: valentina at lists.macserve.net
> Subject: Re: Table structure?
> 
> 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 ???

No.
> This is also not good idea!
> 
I know, I read manual :-)

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

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.

Joakim
> 
> --
> 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]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
> 



More information about the Valentina mailing list