How much data is too much data

Summary: We struggle with reports not running due to too much data. We average about 45,000 open incidents a day. Our oldest ticket is year and a half old. We are looking for ideas from others that have more data volume and how you work through this issue

Content (required): This Report is just using the Incidents table.

Version (include the version you are using, if applicable):

21B

Code Snippet (add any code snippets that support your topic, if applicable):