Could you give a little more detail on this? I have a client running Process Pro (based on Accpac/SBT) and they run the app via TS even for the local users. They have the Z: drive mapped to the PPRO folder. You're saying it's better not to map a drive on the TS machine, but to use SUBST? That's not a command I ever used much and certainly not in quite awhile. Can you fill in some detail on this. Heck, I might just tell all my clients to run my apps via TS if I could take the redirector out of the equation. It seems to be an important factor in relation to some issues that sometimes pop up.

Russell Campbell

>Hi,
>TS will always be faster than access via the network, especially if you use SUBST to point to the data, as it takes the redirector out of the equation. i.e. the Database engine has access to the full bus bandwith of the server for access, where as the local workstations have something less than 70Mb/sec/No. Workstations accessing at that time, under high load this can be lower than 5Mb/Sec.
>
>Mapping a drive to the dataset on the TS will have measureable performance degradation.
>
>UPDATED: A 1Gb link from the Switch to the server does reduce to server bottleneck somewhat.
>
>Also where does the exe reside on the client or the server.
>