D
Dmitri Levin
Guest
Usually the replqueue is very small or empty. However we are on Ver 4 where max number of threads is 5. Well, and DataServer license we have is 5 too. Occasionally the volume of changes in one table (inventory of our goods) exceeds the capacity of 5 threads easily. It happens daily at most active business time 3-5 pm. And thus we have a backlog of on hour or two of that table changes. That backlog ( replqueue ) diminishes off hours and then the queue disappears completely. So we often have many thousands of records in replqueue table. I will wait for version 6 to upgrade. Then we will use "trigger compression". Is "trigger compression" done by default in ver 5 ( in ver 6 )?
Continue reading...
Continue reading...