Hi,
How can I do performance tuning in Reportnet.?
Thanks in Advance
vsudaya
U can do that in various ways. For eg. editing the governor setting in Framework manager and query properties in report studio.
Srik
As BI Srik pointed out there are many places you tune for performance.
Below is from system point of view.
I assume you are using the default Tomcat server. If not then you could do a but more on the J2EE server side.
The first thing you need to do is increase the queue wait time in server administration from the default 30 seconds to more but not too high. Maybe around 60 seconds.
Change the default font in ReportNet ( Andale) to a smaller font such as Arial. The default font is about 26 megs!!! and will slow down all PDF reports.
Change the default gateway from CGI to ISAPI if you are a Microsoft shop. This gives a good bang for the buck.
Disable paging if possible so that all sorting etc will take place in memory rather than on the disk. Setting is in warproperties.xml.sample. Remove the sample suffix and restart server.
Play around with affinity connections and processes.The mor epowerful CPUs can handle 2 processes per CPU.
HTH
NKT