When I refresh data on a report, it takes a very long time to come back. The actual SQL takes only 5 minutes to run in the database, but not sure why Infoview takes forever to return the results. Even Infoview indicates that the Last Refresh Time was only 5 minutes. Is there something else going on that’s causing the long delay? Please advise?
Did you tru to see the logs on how much actual time it takes to refresh the report?
If it’s avery complex report then it would certinaly take atleast 5 minutes for SQL as you said plus the time taken to compute eveyrthing on the report.
Query Execution time (Database side-in your case 5 mins)
Transferring results across the network to the client/web browser (network bandwidth & latency
3)Computing local report variables, formulas, local report filters, alerters, etc. within the report
Rendering the page (page layout, page margins, page numbers, etc.)
I your case I think you should look at 2,3 and 4th step
for more details see this FAQ: Reporter