Question
3
Replies
76
Views
Posted: October 29, 2019
Last activity: October 30, 2019
Closed
Report Definition running slow on 1st Run. But works fine during second run
Hi Team,
Can you please suggest about the reason why the report definition is running slow during 1st run. But the same is running fine in 2nd run. Also, when I have investigated I found out that getcontent activity is taking maximum time in both the runs. For example in 1st run it took 24 seconds and in second run it took 0.7 seconds. I am not sure where to tuneup as there is vast difference between both the runs.
Please let me know if you need more inputs.
Thanks,
Hemant
I'm don't believe I singular answer. Also it may depend what you mean by 1st run.
Factors which might affect this are possibly: -
1. Do any rules need to be assembled during the first run (so already assembled during the second run).
2. Is your DB pool exhausted during the first run (so it needs to establish another connection first).
3. Has the database already established an execution plan. Or is this something that it needs to do during the first run (so already known by the second run).
4. Does the database already have the results in memory (results cache) for the second run.