Kbase P102778: Affects of -SQLStmtCache startup parameter on Fathom Replication ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/10/2006 |
|
Status: Unverified
GOAL:
Affects of -SQLStmtCache startup parameter on Fathom Replication ?
GOAL:
Should the -SQLStmtCache startup parameter be added to both the parent and the target databases?
GOAL:
Will the -SQLStmtCache startup parameter affect Fathom Replication in any way?
FIX:
The -SQLStmtCache needs to be added only to the "QUERIED" database, iow: The database that these SQL queries are being made against.
The -SQLStmtCache does not affect Fathom Replication, as it is a cache needed for queries, not updates or creates.