>>>>>>I run a .prg to count the occurances of certain field contents on a file with 800000 records.
>>>>>>
>>>>>>another user (next to me) tries to bring up printer properties and gets the hour glass but no properties.
>>>>>>
>>>>>>I escape out of the .prg and his printer properties appear...
>>>>>>
>>>>>>What could cause this?
>>>>>
>>>>>Along with Jim Booth's reply, I would add...Where are the TMP files going? Sounds almost like you're doing ALL your work on the network, which will really bog it down.
>>>>
>>>>Would I use a CONFIG.FPW file to direct temp files to the local drive?
>>>
>>>
>>>Yup! One more question that impacts performance, what's the file server? Novell or NT? And if NT, what's the packet size?
>>>
>>>George
>>
>>NT but I don't know the packet size. What size should it be?
>
>NT supports up 4K, Novell 512 bytes. In general, the larger the packet size the fewer requests for data the server should have to process. This can impact your situation. If the packet size is small, FoxPro may be sending requests for data at such a speed, that the server spends all of its time processing its requests. A larger packet size *may* give the server an opportunity to process some other requests. A lot of this is contingent on the record size. Check with your network administrator regarding this.
>
>George

Thanks George, I'm looking into it.