Report generation time is long

[akr]

Hi All,

We have a PDF report which gets generated when a user clicks on custom action of variance object. This is achieved by calling a JSP page, XSL file and query builder. It was working fine in windchill 9.1 server few months before. Now the report generaton time is too long [nearly 10 mins] and we are in a loss whether the issue is because of code or some other performance issue. Please share your insights

[jessh]

It sounds like some basic examination of performance data for this request is in order.

What version is this report running in now? Still R9.1 or 10.x?

In 10.x you can visit the Site -> Utilities -> Server Status -> Monitoring Tools -> Persisted Log Events shortly after executing the report to see summary information about this request's execution. From that you can tell where the majority of the time was spent: in CPU time in the method server or in JDBC call(s) or whatever.

In both R9.1 and 10.x you can get much of this information by simply increasing servlet request logging verbosity to WARN (from the default of ERROR).

From this basic information you should be able to get some idea what to look into next. If most the time is spent in JDBC, then examination of the SQL, explain plan, etc, is in order. A database index might be missing, for instance. If most of the time is spent in CPU time, then some CPU profiling may be in order.

[jessh]

Note that if the issue is JDBC time, you can next use the "Top SQL Sample Intervals" link from the Monitoring Tools page to help discover the problematic SQL statement(s).