<p>Hi,</p>
<p> </p>
<p> I am facing severe performance issues with BIRT . The time taken for the of generation of reports is considerably lengthy.. All my reports use cascading parameter group with seperate data sets for each report parameter and most of the reports have more than 20 columns.. Kindly inform as to where i should tune up to improve the performance..</p>
<p> </p>
<p> Also, if my report has some 50000 or more rows, the report does not get displayed in the UI.. Please reply asap.. BIRT is a part of the application, it uses Oracle 11g as the Database, Java 1.6.0_18 and BIRT 4.4.1 version.. A snippet of the code where i send the report output to my jsp is pasted below..</p>
<p> </p>
<p>Kindly reply asap..</p>
<p> </p>
<p>The variables: task = IRunAndRenderTask, outs = ByteArrayOutputStream..</p>
<p> </p>
<p> task.validateParameters();<br>
HTMLRenderOption options = new HTMLRenderOption();<br>
options.setOutputFormat(HTMLRenderOption.HTML);<br>
options.setOutputStream(outs);<br>
options.setSupportedImageFormats("PNG;GIF;JPG;BMP;SWF;SVG");<br>
((HTMLRenderOption) options).setEmbeddable(true);<br>
options.setBaseImageURL(ctxt.getContextPath() + "/images");<br>
options.setImageDirectory(ctxt.getSession().getServletContext().getRealPath("/images"));<br>
options.setImageHandler(new HTMLServerImageHandler());<br>
task.setRenderOption(options);<br>
engine.changeLogLevel(Level.ALL);<br>
logger.debug(" Generation of Report is initiated. ");<br>
task.run();<br>
logger.debug(" Generation of Report is Successful. ");<br>
String output = outs.toString();<br>
return output;</p>
<p> </p>
<p> </p>
<p>My Viewer JSP: The variable reportOutput = output;</p>
<p> </p>
<p><%@ page pageEncoding="UTF-8" contentType="text/html; charset=UTF-8" %><br>
<%<br>
String reportCode = request.getAttribute("reportCode").toString();<br>
String reportOutput = request.getAttribute("reportOutput").toString();<br>
%><br>
<div><br><br>
<input type="hidden" name="jsFile" value="<%= request.getContextPath()%>/js/base/Desktop.js"><br>
<input type="hidden" name="jsFile" value="<%= request.getContextPath()%>/js/base/xmlHelper.js"><br><br>
<input type="hidden" name="reportCode" id="reportCode" value="<%= reportCode %>"><br>
<div id="birtReportContainer" style="overflow: auto; left: 0px; width: 1150px;height: 600px ;margin-left: 8%;"><br><br>
<%= reportOutput %><br>
</div><br>
</div></p>
<p> </p>
<p> </p>
<p> </p>
<p>Thanks,</p>
<p>Channamari</p>
