A report is taking few seconds to run.The same report is taking very long time on the next day without doing any kind of changes in the report. What could be the reason? how do you tune the report.
Answer / balav
First make sure you,
1. Check for the Backend loads being run on the time of report execution.That might also impact the report execution time.
2. But in future to avoid this long run, you can check the SQL global optimization setting of VLDB properties.
| Is This Answer Correct ? | 5 Yes | 1 No |
Explain the difference between holap and molap?
How do we resolve attribute roles in microstrategy?
Can microstrategy desktop access operational data systems?
How does microstrategy object manager determine if two projects are related?
Difference between project merge and object manager in microstrategy?
Difference between project merge and object manager?
How conflicts occur and what are the ways to resolve them?
What are vldb properties?
Can we access multiple operational databases from within a single microstrategy project?
What is level prompt?
In document how to create metrics?Explain
Explain system call error?