Interesting. Haven't tried this. Will give it a shot.
>Hi Ramil
>
>Not sure whether this will help but you might try setting the refresh down as low as possible
>
>
SET REFRESH TO 1,1
>
>performance may be degrading because of caching.
>
>Regards
>Geoff
>
>>>Ramil-
>>>
>>>>We have an application that uses local views against a VFP database. When we ran our application locally, both exe and data is on the local drive, the performance is good. Opening the application locally three times does not significantly affect the performance of the application.
>>>>
>>>>However, when we have the exe and data on a local area network, the performance drops significantly for every new user opening the application.
>>>
>>>Adding to Mike's reply, it can help your performance if you store local views in their own DBC, and copy those to the local harddrive along with the EXE.
>>
>>We don't really have defined views, instead we create the views on the fly and these temporary views are stored in their own temporary database. We've tried having the exe and the temporary dbc on the local machine and the performance degradation is still the same.
ramil
~~ learning to stand still