Kbase P135041: Where should I implement DataServer for better performance - on Citrix machine or on database machin
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/09/2008 |
|
Status: Unverified
GOAL:
Where should I implement DataServer for better performance - on Citrix machine or on database machine machine?
GOAL:
Which implementation will provide relatively better performance - having DataServer license on the client machine or on the Foreign Database machine?
GOAL:
Where should the dataserver be installed?
FACT(s) (Environment):
UNIX for Oracle DataServer only
Progress 8.x for Oracle DataServer only
Windows
DataServers
Progress 9.x
OpenEdge 10.x
FIX:
For all the DataServer licenses, the GUI or character 4GL/ABL client has built in DataServer module (_oraserv.exe or _orasrv depending on the OS, _msssrv.exe, and _odbserv.exe); therefore, it is called self-service client. The self-service client does not go through the network through TCP port so there is less bottleneck to go through. If the DataServer license is installed on the client machine (Windows or UNIX for Oracle DataServer) or on the Citrix machine, in this case, you do not need to go through the broker (_probrkr or unified broker) to establish the connection to the foreign data source. Also, the schema holder does not need to run as a service which also uses TCP port. The only thing will use the network TCP port is the SQL*NET connection for Oracle or the ODBC connection for MS SQL Server and other ODBC data source.
If the DataServer license is installed on the same machine where the oracle database is, the OCI (Oracle Call Interface) can be used instead of the SQL*NET connection which will also avoid TCP connection. For other foreign data sources, the ODBC connection is required regardless of the location of foreign database.