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.