Cache System Tables

Use the sts_cache_size and sts_full_cache_table_name Replication Server configuration parameters to cache system tables.

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 and rs_users 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.

If you have a lot of replication definitions in the replication system and many replication definition change requests, ensure that sts_full_cache for rs_objects, rs_columns, and rs_objfunctions is off, as any change to a table, which is fully cached causes a refresh of the whole cache for that table.

.

• System Tables that Can Be Cached
  Only certain system tables can be cached.
• Replication Definition Change Process
  If you are making many changes to the RSSD, such as creating, altering, or dropping replication definitions, or customizing function strings, Sybase recommends that before you start the replication definition change process, disable sts_full_cache for rs_objects, rs_columns, and rs_objfunctions, and then set sts_full_cache for these tables to their original values after the replication definition change process.