Replication Server 15.X settings: if properly configured, and you are on ASE 15.0.3 or higher, you can experience extereme performance improvements by setting some/all of the below options.
<ul>
<li>alter connection to ds.db set dynamic_sql to "on"
<li>sqpm_cache_enable, turn on
<li>sqm_seg_prealloc, turn on
<li>sqm_write_flush, turn on
<li>DSI Bulk Option - make use of dsi_bulk_copy
<li>Non-blocking commit, turn on
<li>SQL Statement Replication, turn on
</ul>
Replication Server 15.X settings: if properly configured, and you are on ASE 15.0.3 or higher, you can experience extereme performance improvements by setting some/all of the below options.
- alter connection to ds.db set dynamic_sql to "on"
- sqpm_cache_enable, turn on
- sqm_seg_prealloc, turn on
- sqm_write_flush, turn on
- DSI Bulk Option - make use of dsi_bulk_copy
- Non-blocking commit, turn on
- SQL Statement Replication, turn on
|
|
