Re: Grouping/aggregating data in Crystal Reports
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: Brandon.Allen@xxxxxxxxxxx, <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 18 Aug 2007 10:53:12 +0800
I wonder why "Perform Grouping On Server" is *NOT* the default ?
Is it based on the "understanding" that programmers prefer grouping
on the client
because the clients can do the job faster than the DB server OR DB servers in
development environments are much slower than in production so development
is done with this option set for the client OR that some databases
do not allow
GROUP BYs on the DB Server ?
At 06:55 AM Friday, Allen, Brandon wrote:
List,
I just learned something very interesting about Crystal Reports that
I thought I'd share with the list. By default, when a Crystal
report is designed to do an aggregate operation, for example group
by customer and sum the total sales, Crystal will query ALL the data
from the database, and then perform the aggregation on the client side.
<http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do;jsessionid=E50260AE571FFE68CB5EAD35AA95E8B7?cmd=displayKC&docType=kc&externalId=c2009635&sliceId=&dialogID=1554409&stateId=1%200%201558047>http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do;jsessionid=E50260AE571FFE68CB5EAD35AA95E8B7?cmd=displayKC&docType=kc&externalId=c2009635&sliceId=&dialogID=1554409&stateId=1%200%201558047
In the case I encountered today, this simple change was the
difference between the report failing after 12 hours, and completing
successfully in 8 minutes.
Regards,
Brandon
Hemant K Chitale
http://hemantoracledba.blogspot.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
