>>>Hi Todd,
>>>
>>>Where are your NT swap drive and VFP temp directory located?
>>>This might make a difference if the application can read/write from two drives at once, or if it keeps jumping around on the same drive.
>>>
>>>Steve
>>
>>Hi Steve.
>>
>>I have some water here, and I am convinced that you could change it into wine for me.
>>
>>That was the problem. Everything now points to the same drive and the speed problem vanished.
>>
>>You are the best, man.
>>
>>Thanks again, and again, and again.
>
>Glad to be of service.
>
Some performance suggestions:
(1) Make fixed size swap files, and defrag them immediately.
(2) Make several swap files, one per physical (not logical) drive to let NT direct where virtual memory resides based on device/disk channel loading.
(3) Limit VFP's appetite for buffer space in both foreground and background modes using SYS(3050), especially with several instances running and lots of swap file space allocated. You may find that dramatic performance improvements are seen if you limit buffers to 8-16MB, forcing VFP to discard buffered data it holds "just in case you change your mind".
(4) Force periodic garbage collection as described on the Wiki site at
this URL