Index too big error

[Kenneth Brody]

On 9/6/2016 11:27 AM, Richard Kreiss wrote:
> Windows
> FilePro 5.6
> File 21,535,593 records
>
> Build demand index on
> @cd
> 1 (7,.0)
> 2(5,#)
>
> Dxmaint ran and towards the end showed the error message "Index too big. Change keys"
>
> I have not seen this before error before.
>
>
> 1.      Is there a size limit to a demand index?
>
> 2.      Is this an issue for the Windows version?
>
> 3.      Does this problem exist in 5.8?
>
> 4.      Is there a size limit for auto indexes?
>
> This client has a number of extremely large files
> The largest, just over 21 million and growing (2 of these) - 6.6GB and 3.3 GB
> There are at least 2 files of between 1 and 2 million  records - Under a GB in size

In 5.6, the default maximum size index that dxmaint can build is about 
512MB.  This can be increased using the PFMAXASIZE, PFMAXALLOC, and 
PFMAXTEMP variables.

The 5.6 default values of 32700, 16, and 1000, respectively, multiply to 
approximately 512MB.  The default values in 5.8 are 128000, 128, and 1000, 
giving a default max of about 16GB.

Note that the amount of RAM that dxmaint will use for sorting is PFMAXASIZE 
times PFMAXALLOC.  (Which is approximately 512KB for pre-5.8, and 16MB in 5.8.)

-- 
Kenneth Brody