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?