Throughput

[Former Member]

<p>What is the throughput for the Basic and Professional edition of Crystal Reports for Eclipse? How many reports can be run simoultaneously?</p><p>I am comparing JasperSoft with Crystal Reports. Any comments there?</p>

[SJohnson · Accepted solution]

<p>Hi,</p><p> Unfortunately our engine is not designed to allow me to provide a specific answer as to how many reports can be simultaneously viewed. Our report engine has logic in place to return the requested page of the report as fast as possible. We call this page on demand technology. For the most part these page request are almost instantaneous, however there are a few things can affect how fast the engine returns the report request, such as:</p><ul><li>whether the report requires rendering the entire report (e.g. if you put Page N of M at the bottom of each page)</li><li>how many calculations or external resources are included (e.g. including a Web Service request in each Row of data) <br /></li><li>Printing or exporting - these calls require entire report to be rendered <br /></li><li>complexity of reports - number of formulas, chart, subreports, etc. can have an impact on rendering speed </li></ul><p>Aside from this our engine is not limited by the number of open reports, but rather engine requests. For the most part these engine requests happen so fast that in many cases the CR4E Basic engine will suffice. If a request comes in and the engine is currently in use then the request will be queued up to be rendered as soon as the engine is available. It&#39;s important to mention that even with the Basic edition the engine can handle multiple requests. So with the queuing and caching functionality added to the page-on-demand technology, in many circumstances the CR4E Basic engine will suffice. If you do start seeing slower response times as your user base/number of reports grows then the CR4E Professional engine will provide up to 5 times more throughput than what you experience with the CR4E Basic engine. As well, the CR4E Pro engine can be implemented in a load balanced environment where you can essentially stack the engine on multiple servers to share the requests. </p><p>Out of curiosity, does JasperReports limit the engine to a specific number of open reports? </p><p>Regards,<br />Sean Johnson (CR4E Product Manager) </p>

[Former Member · Accepted solution]

<p>Sean</p><p>Thanks for your input. I haven&#39;t found any numbers specific for Jasper either.</p><p>We are thinking of bombarding CR4E basic with report requests and see what the peak load is.</p><p>Thanks</p><p>--Mak</p>

[Former Member · Accepted solution]

Hi,

I have done some load testing on CR4E and noticed that the number of report requests is limited to the number of db connections available in your db pool.

We're using Tomcat 5.5 and their database connection pooling and have the number of connections set to 120. Our reports rely on the tomcat db connection pool to query the db for our report results. As soon as we make 120 report requests, the 121st request stalls until the 1st report request timeout.

 We suspect the reports hang on to their database connections until report timeout. this is a severe limition as it limits the number of reports you can have open.

I wonder, would the professional version solve this problem?

 --S.

[Former Member · Accepted solution]

You mention "As well, the CR4E Pro engine can be implemented in a load balanced environment where you can essentially stack the engine on multiple servers to share the requests."Â Is this just a licensing difference between basic and pro versions or does the pro version have load balancing capablities not in the basic version?Â