Indexes (was Re: variable lookups possible?)

[Bill Campbell]

On Wed, Jul 21, 2004, Kenneth Brody wrote:
>Bill Campbell wrote:
>[...]
>> >They're the not-often-used demand indexes.
>> 
>> I used demand indices quite a bit when doing bulk imports in the days when
>> automatic indices had a nasty habit of crashing with large numbers of adds
>> (large numbers being about 99 in the Tandy 6000 Xenix systems).
>
>Well, yes, if you imported them in index order.  ;-)

Actually I wasn't.  Adding any significant number > 100 caused the same
problems.

What I did do was (a) build a demand index, (b) delete the automatic
indices, (c) add/update records using the demand index to determine
existing records, while creating new keys, (d) rebuild the automatic
index(es).  Of course this was all done with kludgy programs that ran
Profile16/FilePro via pipes.

Bill
--
INTERNET:   bill at Celestial.COM  Bill Campbell; Celestial Software LLC
UUCP:               camco!bill  PO Box 820; 6641 E. Mercer Way
FAX:            (206) 232-9186  Mercer Island, WA 98040-0820; (206) 236-1676
URL: http://www.celestial.com/

``The Income Tax has made more Liars out of American people than Golf has.''
    Will Rogers