what can I use instead of using report definition in a activity?
We are using external screen for retrieving interaction history information to the screen. therefore, We have a performance problem. Because data is too big. about last 6 mounts. So I need to replace more effective method instead of report definition. Also, I need to find a way using that method for all product. Because report definitions are used in some activities for providing integrity of IH information. so I need to replace too.
I think that, I can use dataset execute method in a activity for retrieving interactionhistory, but if there can be more effective way, I want to learn.
***Edited by Moderator: Pallavi to change content type from Discussion to Question and update platform capability tags***
IH dump for 6 months to be loaded on a screen can be a huge performance hit.
Data sets/RDs are only ways to retrieve the data, but the inline select SQL queries still remain the same.
You need to create aggregate tables to take the summary count instead of running the report definitions on IH table directly.
You need to write an activity that loads the data every day into these aggregate tables and can run your reports on these aggregate tables that store the count and only valuable information like outcome,channel,direction etc.
I would suggest to reach out to a DBA and do the tuning and creating such aggregate tables.
We have seen similiar issue and had to take this route instead of quering the IH Table directly.