Index is too big error (GRX)

[Kenneth Brody]

Quoting Chris Sellitto (Tue, 18 Sep 2007 11:10:21 -0400):

> DXMAINT: 5.0.14DN9
> Windows XP
>
> Hello All,
>
> Does anybody know how to overcome this error?
>
> -----------------------------------------------------
> *** A filePro Error Has Occurred ***
>
> Error Writing Sort Key
>
> On File:
>
> Index Is Too Big
> Rebuild the index using a smaller key.
>
>
>  Press  H -Hardcopy  ◄──┘ -Continue
> -----------------------------------------------------
>
> I am trying to create a demand index on the first 13 fields of a   
> file for a length of 105.
> The number of records in this file is 7,043,444.
>
> Are there any environment variables that need to be set?

http://www.fptech.com/Products/Docs/FPFormat/envvars.shtml#indexes

Check out PFMAXALLOC and PFMAXASIZE.

-- 
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com