Poster is slow for versions 5.1 to version 5.1.7.
The default Post process is single-threaded. It uses one processing thread and One SQL statement is processed and applied at a time.
Multi-threaded Post can, in some situations, improve posting performance by allowing multiple SQL statements from concurrent transactions to be constructed and applied at the same time. Refer to Shareplex Admin Guide for more details.
If running single threaded (STP), switching to Multi-threaded will help with Performance.
Switch to multi-threads poster:
sp_ctrl > stop post
sp_ctrl > set post multi queue <queue_name>
sp_ctrl > start post
In Version 5.3 the default setting for post is Multi-threaded.
Starting with SharePlex 6.x, the single-threaded Post is deprecated. So all references about switching from single-threaded and multi-threaded Post and vice versa will not be applicable in current versions as Post only runs in multi-threaded mode.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center