Partition by vs Group by

[cusacjl]

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

[Blue]

Have you considered using a stored procedure in the database as your data source?

[cusacjl]

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.

[MFGF]

What was the solution?  Set the query processing to be database-only?