Hello … Just wondering how others are cleaning up the buffer tables.
After one of our Sybase databases was progressively getting slower with response time I found a million and a half records in one of the wM buffer tables.
Come to find out that if you configure a notification operation (insert, update, delete) using a where clause the entries in the buffer table are not being removed when they don’t meet the where clause conditions.
So what happens is that any time a insert happens in the table, the record is copied to the buffer table. Then the adapter comes along and checks the record against the where clause to see if it satisfies the condition.
If it does, it will then publish the data to an event and then delete the record from the buffer table. Otherwise it remains in the buffer table until it is manually deleted.
So I was just wondering what others are doing to clean up these entries?