Kbase P152719: Query performance of the remote client is much slower than a self service client.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
24/09/2009 |
|
Status: Unverified
SYMPTOM(s):
Query performance of the remote client is much slower than a self service client.
Query performance of a local loop back remote client is much slower than a self service client.
Query performance of a Progress 9 remote client to a Progress 9 server is about 4 times slower than a Progress 9 self service client.
Query performance of an OE 10.2A02 remote client to a Progress 9 server is about 4 times slower than an OE 10.2A02 self service client.
Query performance of an OE 10.2A02 remote client to an OE 10.2A02 server is about 8 to 10 times slower than an OE 10.2A02 self service client.
/etc/hosts has localhost defined as: 127.0.0.1 localhost.localdomain localhost.
Changing localhost entry to: 127.0.0.1 localhost localhost.localdomain did not change the observed slow performance.
FACT(s) (Environment):
SuSe Linux
OpenEdge 10.2A02 32-bit Service Pack
CHANGE:
The Progress version was upgraded from Progress 9 to OE 10.2A02.
The operating system was also upgraded from Turbo 6.5 Jupiter Linux 2.4.9 to SuSe 11 Enterprise 2.6.27.19-5.
FIX:
This type of behavior is expected given the nature of the kind of client querying tables in a database.
A self serve client accesses the database directly through the shared memory buffers initially allocated by the database broker process, so record retrieval can be very fast. While a local loop back client is running physically on the same machine, it still must communicate with a server process spawned by the database broker to handle remote client connections. Queries are sent to the server via the TCP/IP layer, are processed by that server to retrieve records from the database, which are then sent back to the client - again through the TCP/IP layer. This additional layer accounts for the perceived slower response in retrieving records from a table when compared to a self service client.
Remote clients running on a different server are treated the same way as a local loop back client. However the addition of passing messages across the network between the client and server processes can add more time, when compared to a local loop back client.