fpSQL and the "index is too big" error
Kenneth Brody
kenbrody at spamcop.net
Wed Jan 21 14:36:21 PST 2015
On 1/21/2015 3:53 PM, Richard Veith wrote:
> The problem is that I am running a 'simple' SQL query in the fpSQL window,
> and before it completes, it aborts with "Index Is Too Big. Rebuild the
> index using a smaller key." I am running FilePro on a Windows 7 pc with
> 16 GB of memory (64 bit operating system). The database that I am querying
> has 23.7 million records of 369 characters each. The query is:
[...]
fpsql uses a customized version of an older version of the filePro sort
library, which doesn't take the same config variables.
Try "PFSORTSIZE=1000000".
--
Kenneth Brody
More information about the Filepro-list
mailing list