Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Performance issue Post Reply Post New Topic
Author Message
venky_115
Groupie
Groupie
Avatar

Joined: 15 Jun 2010
Location: United States
Online Status: Offline
Posts: 67
Quote venky_115 Replybullet Topic: Performance issue
     Posted: 13 Apr 2011 at 12:37am
Frnds,
 
I am using crystal reports XI, building a report for investments,using 6 stored procedures in by report grouping by investor, there is  parameter called investor also.
 
if i select the invester the report performance wise and calculation wise is fine but if i run the report for all the investors its goint to outof memroy. please advise its urjent.
 
Regards
venky
Regards
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 13 Apr 2011 at 11:54am
Because you're using 6 stored procedures to return your data, Crystal is unable to push the joins for the data down to the database.  So, it has to pull ALL of the data into memory and then join it together as part of its own processing.  If the data is large, this will cause performance issues and can cause out of memory errors.
 
I would see if you can build a single stored procedure for your report that will consolidate and join the data from your 6 other stored procedures so that you can push the work to the dabase.
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
venky_115
Groupie
Groupie
Avatar

Joined: 15 Jun 2010
Location: United States
Online Status: Offline
Posts: 67
Quote venky_115 Replybullet Posted: 14 Apr 2011 at 10:52pm
Thanks for the answer, but combining 6 stored procedure into one stored procedure is pretty difficult task, there are so many joins are there, time being i informed users to select the investor from the parameter list..
 
Could you tell me how many maximum records can pull the crystal report?
 
Regards
venky
Regards
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 15 Apr 2011 at 4:12am
You could create one stored procedure that calls the 6 others and joins the data rather than trying to fit the logic of all 6 into a single stored procedure.
 
There is no maximum limit to the number of records Crystal can pull when the work of joining and filtering the data is done by the database.  Your errors are coming up because Crystal has to join the data in memory instead of having the database do it.
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.