Home > Forum > Database > Report execution - takes too long

Report execution - takes too long
0

Hello,

I have designed a solution for users so they can access their workflow documents via a simple report, that shows a list of documents with links. This seemed to be the most user-friendly way of presenting documents list.
The report shows a list of documents from specified document flow definition.
Unfortunately, the report runs very slow, even though there are not many documents in the database yet (about 40), and the users have to wait until the page refreshes.
Are there any parameters that I can verify and set to make it run more smoothly? Anything to observe in the database?

Hello Agnieszka,
2 things to check. Firstly you have to check if you have any Calculated Collumns. If Calculated colums have whole SELECT Query it may have huge impact on performancje, becouse it's nested query. Secondly if your workflow works on custom priiliges added by action it may lower your performance. If you have many priviliges added element by element it multiplies amount of etities that report have to check.