Replication Server configuration parameters: sts_cache_size and sts_full_cache_table_name.
You can fully cache certain system tables so that simple select statements on those tables do not require access to the RSSD. By default, rs_repobjs, rs_users rs_objects, rs_columns, and rs_functions are fully cached. Depending on the number of replication definitions and subscriptions used, fully caching these tables may significantly reduce RSSD access requirements. However, if the number of unique rows in rs_objects is approximately equal to the value for sts_cachesize, these tables may already be fully cached.
Table 4-5 lists those tables that can be fully cached.
Tables |
|||
|---|---|---|---|
rs_classes |
rs_dbsubsets |
rs_version |
rs_datatype |
rs_databases |
rs_columns |
rs_config |
rs_routes |
rs_objects |
rs_diskaffinity |
rs_functions |
rs_users |
rs_sites |
rs_queues |
rs_repdbs |
rs_dbreps |
rs_repobjs |
rs_systext |
rs_publications |
|
If you have a lot of replication definitions in the replication system, and you have many replication definition change requests, each change may cause a refresh of the whole cache.
