Hi,
I am involved in a project ,where i am facing performance issues in the Agent Inbox of IC Webclient.
The Agent Inbox search takes a lot of time and sometime fails in the live environment.The reason of the slow response has been identified due to the presence of huge volume of data in the CRM tables. There is a select query which has five major tables in the loop.
The standard CRM tables involved are CRMD_ORDERADM_H , CRMD_ACTIVITY_H and CRMD_ORDER_INDEX.
Due to the presence of huge amount of data in these tables, I am considering the option of archiving the data from these tables in order to free the memory.
We are using Activity Management and IC webclient to record the interaction with the customers.
However, i am not sure of the impact that can be caused due to the absence of data in these tables.Will the absence of data in the fields of these tables have an impact on other or the existing CRM functionality.
Will the absence of data in these fields(above standard tables) hamper the existing functionality .?
Could you please give your thoughts on this ?Any sort of suggestions are welcomed.
regards
Maroof