I guess the best way to fetch data directly from arsystem database views. I have tried all the necessary tip and tricks but not luck with webservices. So create your own view within database and expose the same to third-party. You will see a major improvement.
Regards, Harsh On Thu 26 Nov, 2015 5:02 pm Ashe <[email protected]> wrote: > ** > What if you design your web service to have two operations? One is a get > list to return only ids (and maybe just a few indexed fields?) of records > that match your query and the second is to pull just the data for the > record the client wants to see using the selected ID. This might prove to > be faster overall. It would separate out the time to load each record and > closely mimic the functionality of Mid-Tier. > > > On Tuesday, November 24, 2015 at 11:28:55 AM UTC-5, Terry Bootsma wrote: >> >> ** >> >> Environment: >> >> MidTier Version: 8.1.SP02 Patch 001 201506122355 Hotfix >> >> Java Version: 1.8.0_40 >> >> Web Server: Apache Tomcat/7.0.53 >> >> OS : Red Hat Linux >> >> I'd be interested in getting feedback from anyone who is utilizing BMC >> Web Services and their performance when it comes to larger amounts of data. >> >> For example... >> >> I am querying a form that returns ~ 500 incidents. If I query the form >> directly via a browser from the ARSystem MidTier, the response time is < 2 >> seconds. If I submit the same query via web-services (same underlying >> form) , the response ~= 13 seconds. I know that there is overhead >> associated with SOAP/XML processing, but if anyone has come across any >> tricks/tuning specifically for Web Services, I would be interested in >> hearing from you . >> >> Thank you >> >> Terry >> >> >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ > > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
