Kbase P18431: Can a faster connection be established by shared memory or n
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/03/2003 |
|
Status: Unverified
GOAL:
Benefit of running reports through shared memory rather then across the network?
FIX:
Running a report locally from the database server would be faster then if run from a remote client.
Progress clients that connect directly to a database have access to the databases shared memory. Clients that connect from remote locations connect must connect to a database server process. The server process then establish a direct connection to the databases through shared memory. All request from a remote client are processes by the server process. When a remote clients establish connections to the database via TCP. The client sends the requests to the server process. The server process in turn processes this request on behalf of the client. When the request is finished the data most be translated into packets to be send across the network. When the client receives this packets it must first translate information prior to processing it. The time that it take for the information to sent across the network, unpack and given to the client is additional time. Although network process this information fast, it is not as fast as a client that queries the information directly from the system.