Skip to Content
0
Former Member
Dec 17, 2008 at 07:49 PM

First report run slow...then reasonable.

97 Views

I'll call it a performance issue for lack of a better description. I am accessing an .rpt file on the Crystal Enterprise server and then accessing it using java. It works fine...after the first run of the day. The first run takes up to 2 minutes...while the query itself only takes 2 seconds. We cannot recreate the situation even if all of the Crystal services are restarted and the machine where java executes is rebooted...the only way to make the "slowness" occur is to wait until the report is not accessed from that application server for several hours.

I have timed the slow parts of the code and here were the results:

//46 seconds

ISessionMgr sessionMgr = CrystalEnterprise.getSessionMgr();

//20 seconds

crystalSession = sessionMgr.logon(username, password, cms, auth);

//19 seconds

ReportClientDocument clientDoc = reportAppFactory.openDocument(infoObject,

OpenReportOptions._openAsReadOnly, java.util.Locale.US);

//46 seconds

reportControl.processHttpRequest(request, response,

getServlet().getServletConfig().getServletContext(), null);

Has anyone experienced anything like this?

Travis