Skip to Content
author's profile photo Former Member
Former Member

Concurrent report and performance issues: solution

Hi all,

I'm using

1) Crystal Reports 2008 for the reports' design,

2) Java Reporting Component (version for the integration in java environment,

3) JBoss (version 4.2.3) as Application Server

4) Oracle 11 as DBMS

in a J2EE application.

I created a lot of report using "JDBC (JNDI)" and specifing as the "Connection Name (optional)" the following string

"java:jdbc/name_data_source" and some report using "only definition field".

Currently I am supporting different types of output like PDF and PDF Attachment, RTF, EXCEL.

I am having many performance issues.

Into "Crystal Reports 2008 Component Engine Scalability" document I read that "the Java component runtime engine",

in other words the report engine, "supports a maximum of 5 simultaneous thread per process".

JRC is not meant to be scalable, and utilizes a limited number of report requests handled simultaneously and there is no way

to increase the CPL limit..

For a more scalability, the solution is to go with a server solution like

Report Application Server (RAS),

Crystal Reports Server 2011,

Crystal Reports Server Embedded,

BusinessObjects Enterprise.

Confirmed? Is this approach will resolve my performance problems?

But which of the previous solutions should I choose?

The choice of the new solution, what impact will have on Java code already written with the JRC

and the reports already made?

Thank you very much.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Feb 09, 2012 at 01:30 PM

    It is true that CRJ is not scalable and also faces performance issues. Also please understand that CRJ does not have any license cost associated with it and normally it takes longer to get any fixes etc.

    The server level products offer more scalability and performance as there is more solid framework with improved processes, caching and increased reliability etc.

    Crystal Reports Server Embedded is available only from OEM\Partners of SAP Business Objects.

    Report Application Server (RAS) is not available as standalone service any longer, it comes with both: Crystal Reports Server 2011, BusinessObjects Enterprise.

    Crystal Reports Server 2011 is meant for small- medium sized deployements and Enterprise level product more suitable for medium- large deployments.

    You can consult with Sales for choosing the right product for you. As far as code is concerned, there in't much change since RAS PIs are superste of CRJ APIs and report viewing\exporting APIs and exactly the same in both.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.