Performance Enhancements

Replication Server 15.7 includes several changes to improve replication performance.

• SQM Command Cache
  Use the SQM command cache to store parsed data from the Executor thread that the Distributor thread can retrieve directly, and therefore improve replication performance.
• Executor Command Cache
  Use the Executor command cache to cache column names and datatypes for a primary Adaptive Server database table, when a Sybase RepAgent initially sends an insert, delete, or update LTL command for that table.
• Higher Limit for sqm_cache_size
  The maximum limit for sqm_cache_size has been increased to 4096 from the previous limit of 512.
• Dedicated Daemon For Deleting Segments
  Set sqm_async_seg_delete to on to enable a dedicated daemon for deleting segments and improve performance for inbound and outbound queue processing.