Skip to Content
author's profile photo Former Member
Former Member

QUERY_VIEW_DATA Performance issues

We are on BI 7.0 and using QUERY_VIEW_DATA to expose SAP BI data as web service.

The web service works fine if the number of records(16 columns) returned is less than 1500 rows(45 second response time). The response time increases exponentially as the number of records increase and times out at around 5000 records (time out is set to 5 minutes).

I have traced the oracle calls and the problem does not lie there. Also, running the function module RRW3_GET_QUERY_VIEW_DATA performs very well(55K records in less than 2 1/2 minutes). So, I think ABAP is not the issue.

That leave the java components. I think the generation of the XML document is the one which is causing the performance issue.

a) Is there a tool to pin point what the issue is?

b) Is there some Java settings related to web service that can be changed to improve the performance?

c) Is there a way to remove some of the XML pay load that gets automatically generated. Consumers of the web service don't need all the XML that is being created. This will reduce the time to construct, pass and parse the XML.

Thanks,

Vinod Swarnapuri

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 02:19 PM

    Hi Vinod, We are trying the same. But still trying to get the web service to work. Worked out all the auth issues etc. Would appreciate if you could let me know how to find out the parameter ids for any query to use with the service. Would it just be the technical names of the variables?

    Would be very curious to know what and how you fixed the performance issues.

    Thanks in advance,

    Dilip

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 02:31 PM

    If need be arised to increase the ABAP memory performance issues may wish to check this - SP18

    Note 1156897 - Optimization of memory release in ABAP, planning functions

    Youo can use tcode - SNOTE to just import it and give it a shot.

    Hope it Helps

    Chetan

    @CP..

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.