Since I'm not sure exactly what you're doing, I'll tell what my instincts tell me.

If you haven't done any memory optimizations with the amount of available memory to VFP (using sys(3050) returns more memory than what you have in RAM.).

The overall effect is that your program is "fooled" into thinking that it has more RAM than it does. So it goes really fast to a certain point and then all of a sudden starts to slow down, right? At the same time, hard disk activity increases because Windows is "swapping" out memory. So of course the processing gets slower as Windows has to constantly swap out memory from your Hard drive to RAM.

I think for a 32MB RAM machine, the magic command for optimization is Sys(3050,7500000).

>Hi,
>
>My simple application written using VFP 5a for updating, inserting and deleteing records, the first time is run, processing of records speed is
>fine.
>
>However, when it reach maybe the third and sequential file for processing, it just really slow down the processing speed to around 30 - 60 minutes.
>
>The processing speed/time of a file is around 5 minute plus only because my clipper DOS version of this application take around 5 minutes to
>process each individual files.
>
>My system is running on Win95 with 32M of RAM, 1.7G of harddisk.
>All the database files had their own CDX, index file.
>Running of Win95 system monitor show the processor time is 100%
>and the Win95 resource is constant throughout. ( around 88 %)
>
>What could be the cause of my application running very slow ?
>
>Could it be due to when opening all my master databases files which are around 100M plus. There are some master database file that are always open. Could it be cause by VFP loading all the huge database file causing the problem.
>
>Any advise or comment is very much appreciated.