Slow OpenDoc Performance

scheduling XI Scheduler
1

Hello,

Firstly, everything works so this is purely a performance question (which I know can be difficult to nail down at times)

My Setup:

  • I developed a Crystal Report that pulls back all data (Employee Report)
  • Employees are grouped by department
  • I created a parameter that will filter based on department and added it to the saved data select expert
  • In BO 4.1 I created a schedule to run the report daily

To test:
I created an openDoc that references the last instance of the report:

http:///BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=&sIDType=CUID&sInstance=Last

This returns the full instance within seconds.

I then added the name of the parameter (which should filter the saved data)

http:///BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=&sIDType=CUID&sInstance=Last&lsSEKEY=InfoTech

This returns the employees in Information Technology in about 2 minutes

I recognize that the instance would take a “little” longer to go through the entire instance and filter, but I can’t see it taking that much longer than when there isn’t a parameter passed through (in fact I would suspect because data is being limited it might even be faster)

Am I not fully understanding the way this functionality should work? 2 minutes to filter an already scheduled and completed instance seems a bit off to me.

Are there any ways I can improve the performance of this? Again, everything works, it just seems to be an issue of optimization in my mind?

any help would be appreciated! :hb:

ctsui7 (BOB member since 2013-04-09)

2

How many rows of data are in the unfiltered report? Any filtering that happens after the report is processed is done completely in memory. So, the speed is a function of the size of ALL of the data in the report, not a function of how well the report processes.

It might be more efficient to have a schedule for each department and have OpenDoc open the instance based on the Department parameter instead of using a filter.

-Dell

hilfy :us: (BOB member since 2007-04-16)