Indexes (was Re: variable lookups possible?)

Bob Stockler bob at trebor.iglou.com
Wed Jul 21 16:40:31 PDT 2004


On Wed, Jul 21, 2004 at 07:35:18PM -0400, John Esak wrote:
| > > 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.  ;-)
| >
| > Back then, indexes weren't self-balancing, and had a depth limit of 100,
| > after which you would get filePro error 17:
| >
| >     Automatic index too unbalanced.
| >     Run Index Maintenance to rebuild the index.
| >
| 
| God, I remember those days... and people thought the DKNF boxes were
| annoying... :-)  Now, many of my indexes are in the hundreds of thousands
| and zero problems... (knocking on every piece of wood he can find). :-)

But, as I remember, you were warned in advanced that
adding records in index order was a no - no.

Bob

-- 
Bob Stockler - bob at trebor.iglou.com
Author: MENU EDIT II - The BEST Creator/Editor/Manager for filePro User Menus.
Fully functional (time-limited) demos available by email request (specify OS).


More information about the Filepro-list mailing list