Time Sheet Report doesn't prevent from fetching to many issues from filter

[BartłomiejW]

Time Sheet Report doesn't prevent from fetching to many issues from filter which casuses large memory consumption and sometimes out of memory exceptions.

[Andriy Zhdanov]

Hi Bartłomiej,

I'm thinking of configuration option to limit number of issues in filter. What do you think would be the maximum number of issues allowed by default? Do you have any experience in your environment?

Thank you.

[Artur Karpiński]

Hi Andriy, I'm working with Bartłomiej. We think that maybe 500 issues would be optimal in our case. It would be also good feature if generated report had information that administrator limited number of issues if user used filter that can return more issues than limit,

[Andriy Zhdanov]

Hi Artur,

500 is very little number. I've tried on 20K issues, with no problems on development environment. Production environment I would think should be capable of much more.

Also, if I do this, report will not produce any result, but an error, that filter has too many issues, not to mislead with non accurate data.

Thank you.

[Artur Karpiński]

Hi Andriy,

Maybe I'm to cautious. Our users executed queries that generated reports with html that had size > 1 GB. So we need this feature to prevent OOM with any default settings.

[Andriy Zhdanov]

Hi Artur,

It may be fixed also be reducing time period (see Maximum Period plugin configuration option) and not using detailed report (See Show Details report configuration option). The latter is automatically switched off on huge reports, configurable by Worklog Limit configuration option in Administration - Add-ons - Timesheet Configuration. See also Issue#169.

Please let me know if it helps.

Thank you.