some questions

[Russ Tyndall]

On 7/18/06 10:11 AM, "Ruslan Zasukhin" <sunshine at public.kherson.ua> wrote:

> 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

Ok, no problem. Wasn't working very well, anyway.

-- 
Russ Tyndall
Wake Forest, NC