Sunday, January 29, 2017

If Report Definition is taking much time to execute, what are your steps to debug it

  • Execute report definition stand-stalone with tracer on with DB query setting. Capture the query.
  • Or look at clipboard page pyReportContentPage which would give exact query that was run.
  • If we have query we can easily identify why it is taking much time.
  • We can watch out if any unoptimized properties used in the report.
  • We can check if indexing would improve the performance.

No comments:

Post a Comment

HowToPega : All rights reserved and the contents are copyrighted to Pavan Kumar Naidu