Is there way to optimize (speed-up) performance of the repository Activities query tool

[BenAvdicevic]

Hello,

Environment description:   HOPEX V5 CP7 HF17

In our environment, we have the Activities tile under Collaboration menu.  It is very useful tool because it lets us see who is making changes to repository objects.

The issue is - the search function is very slow.   Trying to search "30 days" of history can take upto 2-3 minutes.  Search through any window larger than 3 months often just times out.

I am wondering if there is a configuration change to make this type of search faster ?

[BenAvdicevic]

@AHassan Thank you.

We are SaaS customer so we can't make this change ourselves.  We will ask our MEGA team for advice. 

Thank you!

[AHassan]

Hello,

Give it a try to add these parameters to Megasitesettings under their respective heads - we have experienced a lot of improvements when running the queries in general.

[Debug]
QueryResultCache=0

[System]
QueryResultCache=0

[Gbm]
BdSelectOptimize=0