Skip to Content
avatar image
Former Member

Nearline:Query Performance Issue

Hi All,

Here is my issue:

If query with online data executes 4 minutes and 30 secs.Query with archive data fetching more time i.e 14 mins 30 secs. and sometimes one hour.

What are the checklist i need to check in this case.

IAny valuable inputs appreciated.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Sep 11, 2014 at 11:34 AM

    Hi Satya,

    Please look in to the excellent blog written by Suman Chakravarthy K

    http://scn.sap.com/community/business-explorer/blog/2013/07/25/how-to-optimize-reporting-performance

    Follow the steps explained in the blog.

    Regards,

    Krishna Chaitanya.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 11, 2014 at 07:54 AM

    Go to ST03 transaction and analyse the run time statistics for a query.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 11, 2014 at 11:10 AM

    Hi Satya,

    Execute your query in RSRT with debug mode on statistical data and execute.

    Check where it is taking time It might useful for you.

    Regards,

    Ganesh Bothe


    Add comment
    10|10000 characters needed characters exceeded