Consultor Eletrônico

How do users of AppServer affect database performance


Each time an AppServer process connects to a database, performance
will be affected in a manner identical to that of adding an
additional user connection. In other words, there is no special
case where AppServer connections are involved. If a PROGRESS client
connects directly to a database, then spawns an AppServer process
which also connects to the database, then this will be seen by the
database as two connections -- the database will not make any
distinction due to the fact that these two connections happen to be
a consequence of a single PROGRESS client executing on a node
somewhere.

Perceived performance may be different when comparing the client's
direct db connection with the AppServer connection, if the AppServer
process executes on the same node (machine) as the database. Since
the AppServer process will be connecting to the database via shared
memory while the client connection will presumably be across a
network, it is expected that performance of the AppServer connection
will be better. It is important to note, however, that this
performance will be from a client perspective, not the database
itself. AppServer processes are faster due mainly to the way
they are configured, not because the database gives them any
special treatment when processing requests.

Progress Software Technical Support Note # 16187