We have a report that is reading 500K records...it returns the result back to the CRN server for it to crunch the numbers. As a result, it is taking 60+ minutes to build the report. We've narrowed down the reason to be a partition by vs a group by. We want the DB to do a group by to consolidate that 500K down to something much smaller (10K) then return it back to the server.
Is there a way to make this happen?
We're using an oracle db - CRN 1.1. Thanks.
John
Have you considered using a stored procedure in the database as your data source?
No we have not.
We have resolved this issue and was able to get the report to do a group by instead of a partition by. The performance went from 4 hours to a little over 30 minutes generating a PDF with over 270 pages. Same report generating 120 pages generates between 15-20 minutes (vs over 4hrs). 50 pages which took 20-30 minutes before now takes 2-4 minutes. 15 pages use to take 15-20 minutes and now takes 1 to 2 minutes.
What was the solution? Set the query processing to be database-only?