Close popover
Abikash Kumar Sharma (AbikashSharma)

AbikashSharma Member since 2014 15 posts
Posted: February 14, 2019
Last activity: February 26, 2019

Activity method Queue vs Queue-For-Agent

We have a requirement to keep a track of all important user action in application. So on every important user action like search, update as case, advance a case we make an entry to a custom table. Our approach is to use Queue method in post processing activity and call the activity (say InsertLogs) that inserts a record in custom table.

It works fine until under normal circumstances but during high load we get few DB deadlock errors or the database takes longer time to run the merge DB script that is called from the InsertLogs activity.

Is there any better approach to handle this scenario? Can Queue-For-Agent perform better if we queue all the requests and process with a standard agent in every 2 hours or so.

***Edited by Moderator: Pallavi to update platform capability tags***

Data Integration Java and Activities System Administration
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.