>>>We have a simple application that runs well whether as standalone or network environment provided there is no other application sits on the server (VB/DELPHI/POWERBUILDER etc. apps).
>>>
>>>Problem is, when the application is installed in a network environment that has huge users say 200, coupled with different apps done in different tools, our VFP app slows down. The weird thing is, the VFP app is being access only by 1 user.
>>>
>>>One guy says that it is one of VFP's weakpoint, when it is mixed with other application and being access by huge no. of users, VFP app slows down.
>>>
>>>Any input is highly appreciated!
>>
>>When network is overcorwded any application (not only VFP) will slow down. Obviously, that the high traffic will affect more applications that rely more on moving big chunks of information over the lines, and it does not matter actually why line is busy (because of many VFP or non-VFP users). I would look at the way the application retrieves data, especially on SELECT_SQL statements. Some of them may really hit the wall. I do not mean plain issue of Rushmoring, actually Rushmore itself may raise network traffic too high.
>
>Hi Edward!
>
>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.

It's still possible that SQL is used explicitly, e.g. as list/combo rowsource or grid.recordsource. Also, you can use SET COVERAGE to analyze what part of form slows down its opening.