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