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.