I opened a Crystal Report in BO Enterprise on my desktop in Crystal Designer and pointed to the database and ran report - report is taking a really long time to run.
If I open the same report but DO NOT login to Business Objects (BO) and repoint to the exact SAME database and run report - it runs really quick.
Any ideas why this is happening?
How is the same report - opened from email in logged in mode (Logged in to BO) work differently from if I open same report, point to the db and run?
There are many variables associated to it, application server, crystal cache server, crystal job server, creation of .epf pages in between, volume of data… its taking a long route when you are logged into Enterprise. I would advise you to ‘Schedule’ the report in Infoview… it will be faster.
Without logged into Enterprise is a shorter route to bring the data… hence less time.
You also have to look at what kind of load the rest of your BO server is running - if there are other reports running at the same time, that can slow this down. This is also affected by the amount of memory on the server, the CPU speed, the disk speed, and network latency. If the web tier and Tomcat is installed on the report server, that will also affect report speed.
When you run the report locally in Crystal, you don’t usually have other things going on that take up CPU and memory.
(BOB member since 2004-06-06)
(BOB member since 2007-04-16)