Speed generating report

[Former Member]

We are considering C11 coming from C8. The file we access contains 65000 records. To generate a report using C8 takes seconds. Using C11 it takes 20 to 30 minutes. We have 100+ of reports running against the file. Called the help desk and all they could say was, 1. purchase the schedular $2500 and generate reports at night,(data base we access is updated at night finishing around 7:am, 2.hire a contractor to convert from C8 to C11, roughly $100,000. Excuse for the problem is broken links. When the reports do generate they amounts are correct. C8 would increment the records by the 1000+. C11 increments by 30-40. Buffer issue? Does anyone have a legitimate solution other then the two given? Converter program? Change of Crystal options? Oh, going to C11 for the use of Crystal viewer which does not work on C8.

[Former Member · Accepted solution]

Jason

I will try that. One if the files connect is coming from a Oracle db, one from access, and one from excel. Thanks.

[former_member260594 · Accepted solution]

Returning record sets from 2 different datasources will take extra time as the 2 result sets will be joined by CR which is not as efficient at doing so as a databse (though I understand that doesn't explain why it worked properly in 8.5).

As you are using Access you might want to consider linking from Access to your Oracle tables. Crystal will then see this as one datasource and will probably be even quicker than it was in 8.5

[Former Member · Accepted solution]

Good morning

I moved all of my files to a access db. Indexed them. Did not see any change in speed. The report has 777 formula and running total fields also. But, that does not explain the performance of C8 to C11. I have been doing some other testing and have yet to find C11 come close to C8 in any file. If I use a single file as input, C11 performs as well as C8. I removed all of the calculations, 777 of them, set to run directly against the access db, had the poor performance. I am beginning to beleive that C11 has coding issues like branching within program to do there reads rather than loading directly into program. Branching for many subroutines rather than performing, IE keeping the code resident. Buffering of there input area. Array's or table definition within program.

[Former Member]

Michael,

You could try refreshing the links through Database > Set Datasource Location...

Without any more specifics, it's hard to give you any more ideas.

What type of database are you using as your data source?

A single table with only 65,000 records should be no problem.

Jason