cancel
Showing results for 
Search instead for 
Did you mean: 

Running reports in CMC is Slow (the first time)

Former Member
0 Kudos

when we first log into CMC - the report takes 10 minutes or more to run.

when you run it subsequent times - it takes less than 15 seconds...

what could be causing this unbearable delay the first time?

I've seen some people say that you should build a blank report that users can run first - that is not a solution....

Has anyone had a similar experience?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Check the same query on DB, notice how much it takes to run.

What might be happening here is, first time when it ran, that may be normal time it takes to run the report. After that, WEBI processing server (assuming you are running WEBI report) keep it in cache, so next time when it runs for the same data, it takes it from the cache, instead of querying the DB again. That is the reason, you see the results quickly.

Former Member
0 Kudos

Sorry should have mentioned it is a crystal report running off our ECC database  (it has nothing to do with ECC performance - I'm never running above 20% usage on my servers)