Terry, Is the username for the direct query on the mid-tier and that used by the web service the same? If one is a user and the other an admin, these are different threads. Totally guessing here but that could be it.
Mark From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Harsh Sent: Thursday, November 26, 2015 7:11 AM To: arslist@ARSLIST.ORG Subject: Re: Web Service performance - MidTier ** 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 <ashe....@gmail.com<mailto:ashe....@gmail.com>> 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_ _ARSlist: "Where the Answers Are" and have been for 20 years_ ________________________________ This E-mail and any of its attachments may contain Time Warner Cable proprietary information, which is privileged, confidential, or subject to copyright belonging to Time Warner Cable. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"