Consultor Eletrônico



Kbase P25743: Is the limit of 1000 statements defined by CACHED_STATEMENTS
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   5/23/2003
Status: Unverified

GOAL:

Is the limit of 1000 statements defined by CACHED_STATEMENTS or -SQLStmtCache per connection or per database?

FACT(s) (Environment):

Progress 9.1D

FIX:

The CACHED_STATEMENTS is per connection, it is not shared among connections. So
5 connetions 100 each would result in 500 cached statements.