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