QUERY_VIEW_DATA Performance issues

[Former Member]

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

[Former Member]

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..

[Former Member]

Also check

Hope it Helps

Chetan

@CP..

[Former Member]

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