some questions

[Ruslan Zasukhin]

On 7/18/06 3:25 PM, "Russ Tyndall" <fitzbew at nc.rr.com> wrote:

>> * VarChar slow down OPEN only if you have e.g. 100 VarChars in db.
>>   if you have 5-10, no significant affect.
>> 
> 
> My "slow open" problem, discussed at length yesterday, went away when I
> dropped a table that only had 2 varChar fields.  But even with those two
> varChar fields, my db only had 6 varChar fields and only 1 was indexed.

> *BUT* my db has 40+ String fields that are indexed.  So --- to work around
> my problem -- should I concentrate on converting those varChar fields to
> some other type, or spend time getting rid of indexes?
 
> So far, trying to use String fields causes the db to balloon mightily in
> size, but I've just barely started experimenting yet.

Don't do anything for now

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