Working in apex 20.1 - I have an IR built on a table that has 6 million records in it. Obviously a performance hit to pull all 6 million records. I tried using the "Maximum Rows to Process" setting and it definitely helped the performance, but the issue is that there are times when the users will need more records than what I set as the max (100,000).
Is there any way to make this setting dynamic? I'd love to add a button that removes the limit and adds a warning that they will have to wait for the results. Just not sure what my options are - I did find a hack where someone updated the back-end table with a page item variable but I'm not quite ready to go to that level of ugliness.