AnsweredAssumed Answered

Portlet Filter Performance issues

Question asked by JoostBreggeman76041091 on Jun 17, 2016
Latest reply on Jun 24, 2016 by Chris_Hackett


Hi,

 

I have an issue with one portlet which has a relatively simple query associated to it. It's a one dimensional query pulling data from a couple of tables using joins. Nothing special.

 

If I run the query direclty it returns all results in a few seconds. However, in my portlet it takes almost a minute. I found out that if I remove most filters the performance goes up again, so it must be somewhere in the portlet configruation setup. The query seems to be fine. It typically seems to 'hang' when filtering on resources and/or departments.

 

Nevertheless I am running out of options here. any idea how to fix this?

Outcomes