You can try to limit the size of VFP buffers

SYS(3050, 1, 64*1024*1024)
SYS(3050, 2, 64*1024*1024)

Also try to call SYS(1104) after command that process large tables. It clears memory cache and buffers.

>one of our client free DBF is growing very fast and the size is now close
> to 1.3 gig. Client Run an indexing utility that run ok by itself but when
> it ran under a scheduler written in VFP, it is reporting the following eror:
>
>" Not enough memory for file map (Error 1150)"
>
>The server that this test is running at has 512Mg
>then the same test ran under with one gig Server and still did not get a
>successfull indexing.
>
>The total size of DATA directory indexed is 5 gig, The biggest file is 1.3 gig in size, Free disk space is around 30 gig.
>
>
>I ran the same test on windows 2000 Server with 512Mg and scheduler would
>take tremoudous amount of resources when the indexer routine is laucnhed then Server lock up and had to end the task.
>
>
>I checked VFP help regarding the size of cdx, I do not see any limitation, I do see that max size of one table is 2 gigabytes.
>do you think this limitation apply to cdxs as well?
>
>Any help on this would be greatly appreciated.
>
>
>jhhaidar@pacbell.net