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, rs_users rs_objects, rs_columns, and rs_asyncfuncs 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 you have many replication definition change requests, each change may cause a refresh of the whole cache.

• 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.