Index too big error

Richard Kreiss rkreiss at gccconsulting.net
Tue Sep 6 08:27:13 PDT 2016


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



Richard Kreiss
GCC Consulting


-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 15756 bytes
Desc: not available
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20160906/083b90e6/attachment.bin>


More information about the Filepro-list mailing list