Increase performance

[jrcol12357]

CR XI, I have a report that includes 127 columns and is to be setup as excel data only export. I'm getting my data from two different data sources in which I'm not allowed to access with one view. So I have joined the two views together by an id number (outer join) in Crystal. My performance on this report is ugly. It will return 50,000 records but you can count them as they come in 1....2.....3 and so on. If I run each view on its own the data is returned in a matter of seconds from each data source. How can I run this report quicker with the two views joined in the report?

 

[Turkbear]

Hi,
Can you access each view alone - If so, how is the performance?

Is the ID number in each view an indexed field in the database tables that comprise the view.

Are you grouping by any values?






To Paraphrase:"The Help you get is proportional to the Help you give.."