Kbase P89725: Is it normal C/S users wait longer for data when there is a Self Service user?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
Is it normal C/S users wait longer for data when there is a Self Service user?
GOAL:
Should remote users "suffer" from local users?
FIX:
NO.
With a well tune database and no bottleneck on the machine, it is not common situation that Progress send data to C/S users (with remote connections) slower if there is also a SS user (with shared memory connection) for the same DB server.
An additional remote server would be equivalent to an additional Self Service client as per the database resources needed.
If a bottleneck on the machine appears with the additional self service client(s), then you see less good performance for remote users.
The CPU usage for non database access, the private shared memory segment size for variables and workfiles, the I/O for temporary files (sorting data, accessing temp-tables,.. ) of the self service client will remain the same if it becomes a remote client by using TCP/IP loopback, having added the -S connection parameter.