>Jess,
>
>>We rarely use SQL-Statements when manipulating and retrieving data especially if using Native VFP table. We often use CURSOR combined with statements or functions with WHILE capability. According to our Technical Staff, he saw the difference bet. VFP apps and other apps, and sad to know that our apps really slow when form is being executed for display, considering that, it is being accessed only by one user since it is still installed as Demo application. Other apps BTW are being accessed by numerous users.
>
>The real problem, I think, is the network load. The actual number of users using a specific app has nothing to do with it. You may want to check your app if networktrafic can be reduced. There are numerous techniques to reduce network trafic. One of them is rushmore. Another one is to download only this data you actually need.
>
>Last week,for example, I went to a client who had serious performance problems when starting a form. It seems to be that they used views, which were inmidiately requeried when the form was displayed. In this case it's wise to set the NoDataOnLoad property to false, as it does not execute the query when loading the dataenvironment.

In this particular case, we do not use views since it is not client/server. At this point maybe I have to go and investigate it myself. Thanks anyway!

>Walter,