I have a Classic Report with Number of Rows property as 10000, Max rows property as 10000. For cases where the query returns more than 3000 rows, the page shows performance issue. It pulls the records quicker and page is partially rendered, but it waits at a step "Rows loop: 10000 row(s)" for a long time. There is no Database activity for my user session, but the page waits to load completely.