>>>I have a user that have the application installed on the server and running it from the desktop using shortcut.
>>>The application is running very slow as oppose to the desktop installation.
>>>
>>>How to troubleshoot the cause of this problem???
>>>
>>>Thanks
>>
>>Copy application to client machines just leave data at server. Running .EXE at server and create .TMP files at server cause really slow on network. We lived that problem and solved by this way.
>
>If I'm not mistaken, temporary files normally go to the local temporary folder regardless of location of EXE file (unless you specifically override it in the CONFIG.FPW file). You can use SYS(2023) to see what directory it is during runtime.
>
>If we're talking about speeding up a program that uses DBF files, putting EXE on local drive and keeping data on the network drive is at best a partial solution. It may address program startup load, but it doesn't address the impact of loading and storing of data through the network. Once the sizes of the DBF files gets to a certain point, you'll not see much of an improvement, as much of the slowness ends up as a result of the large DBF files being transferred across the network. Although using CDX files could help, but once they reach a certain level of complexity, you may get a performance hit from the time it takes to transfer the entire CDX file across the network.

The DBF is not transferred acorss the network. The entire CDX is also not transferred. Rushmore extracts only the bits of the cdx it needs to meet a filter or where condition and then only the records needed are sent. The exe is constantly being re-read. Having it on the server is not just slow at startup but throughout the time the app runs. Removing it to a local pc removes that network traffic and improves access to data for everyone. Only a remote database backend could do better.