Hi all,
I was hoping someone can confirm if this is normal behavior for a view. Our application (VFP7 SP1) is running on a Citrix server running on Win2K which is part of a Windows domain. One of the VFP table is about 1.5 GB. The database is located on the same server. The application is slow by VFP standards; 2.5 secs average to refresh a grid. Then suddenly, the response time spike to 30+ secs! No code change whatsoever, even a second dataset, same application, which had a 1.7 GB table had better response time!
After much hassle and investigation, we found out that the DataLoc, one of the framework property that holds the directory/folder where the database is stored was using a UNC path. This is the comparison of the two settings:
Setting 1 Setting 2
Server : SRV01 Server : SRV01
DataLoc: Dataset\Zone1 DataLoc: \\SRV01\D$\Dataset\Zone1
Avg refresh: 2.5 secs. Avg refresh: 30+ secs.
After the DataLoc was reverted back to Setting1, everything went back to normal. I would very much like your feedbacks and/or comments about this behavior.
Thanks.
ramil
~~ learning to stand still