>However, available memory (as reported by System Monitor) is still going down. I ran approximately 11,000 transactions through in a seven hour period. Allocated memory increased by close to 2MB and free memory decreased by about 800K. All I'm doing is a couple of Seeks and a couple of Replaces. I HAVE noticed that not setting the Index Tag in the SEEK statement seems to improve efficiency.
I would consider that normal. As I mentioned VFP pulls more memory as it needs it
and releases it when the system asks for more memory. I have 4 VFP servers running
for several days on end with 200-300,000 requests per day and while these servers
eat up a lot of memory they stabalize right around the treshold of physical memory.
IOW, they'll take as much as they can get away with, but only gradually build up
to that.
If I then idle these servers up, and then fire up another resource intensive task
you'll see resources falling back down to 'normal' levels of a 4-5 megs.
Using SysMon to track memory this way is useless as you can see.
+++ Rick ---