Hello Experts,
In our environment, the taskspace user inbox takes about 5 minutes to be loaded when the user has about 50 tasks. The problem occurs when we include SDT in our inbox. In fact, we have included only one SDT in our custom tasklist form, and the number of items in dmi_queue_items, audit, dm_sys_object are not very huge (around 50 000).
In addition to loading time, it does not display all the data from SDT. Sometimes, it sometimes displays some data form the SDT, on the second refresh it displays some other part.
I have analyzed the DFC traces generated from the tasklist form, it show that there are about 10 queries that are repeated about 200 times each if the inbox has this problem.
Please help me to find out the possible cause of the issue if you have ever faced something similar.
Thanks in advance