Hi Folks, Happy holidays to those of you who celebrate.
I am still struggling with the performance problems associated with a "get-list" web service. Does anyone know if it is possible to return multiple records from a filter that is invoked by a "service" type of web service? And Misi... regarding the behavior mentioned below, all of the generated SQL commands are part of a single ARXMLGetEntry API call. I sure wish we had a little move control over this. Thanks. Larry On Fri, Dec 16, 2011 at 2:13 AM, Misi Mladoniczky <[email protected]> wrote: > Hi, > > I do not see how you can do much about this, it is how it has been > "optimized" by BMC. > > To know in detail, you may need to turn on API-logging as well. > > I suspect that you are seeing first a ARGetListEntry(WithFields), followed > by an ARGetMultiplEntries. > > I guess they have been lazy in this case, as they should only need the > ARGetListEntry(WithFields) call when you do not need any fields such as > big character fields. > > Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) > > Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): > * RRR|License - Not enough Remedy licenses? Save money by optimizing. > * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. > Find these products, and many free tools and utilities, at http://rrr.se. > >> Hi Folks, >> >> I have a basic question about how web services work. >> >> I have defined a "get-list" web service that takes a user-specified >> qualification and returns the "Entry-Id" (field C1) of the records that >> match the qualification. No other fields are returned. I was expecting >> this >> to generate a single SELECT and return C1. But I am seeing something quite >> different in the SQL logs. >> >> I do see the expected SELECT, something like this: >> >> SELECT >> T282.C1,C8,C3,C7,C536870935,C536870938,C536870913,C536870967,C6,C536870940,C536871010,C536870973 >> FROM T282 WHERE (T282.C3 >= 1322715600) ORDER BY C536870935 DESC,C3 ASC, 1 >> ASC >> >> But instead of returning the C1 values from that SELECT, the server >> fetches >> each record individually to get the C1 values. I see "a bunch" of SELECTs >> like the following: >> >> SELECT C1,C1,C1 FROM T282 WHERE C1 IN ('01605119', '01605121', '01605122', >> '01605123', '01605124', '01605125', '01605126', '01605127', '01605128', >> '01605129', '01605130', '01605131', '01605132', '01605133', '01605134', >> '01605135', '01605136', '01605137', '01605138', '01605139', '01605140', >> '01605142', '01605143', '01605144', '01605145', '01605146', '01605147', >> '01605149', '01605152', '01605153', '01605155', '01605156', '01605157', >> '01605158', '01605159', '01605160', '01605161', '01605162', '01605163', >> '01605164', '01605165', '01605166', '01605167', '01605168', '01605170', >> '01605171', '01605172', '01605173', '01605174', '01605175', '01605176', >> '01605177', '01605178', '01605179', '01605180', '01605181', '01605183', >> '01605184', '01605185', '01605186', '01605187', '01605188', '01605189', >> '01605190', '01605191', '01605192', '01605193', '01605194', '01605195', >> '01605196', '01605198', '01605199', '01605200', '01605201', '01605202', >> '01605203', '01605204', '01605205', '01605206', '01605207', '01605208', >> '01605209', '01605210', '01605211', '01605212', '01605213', '01605214', >> '01605215', '01605216', '01605217', '01605218', '01605219', '01605220', >> '01605221', '01605222', '01605224', '01605225', '01605226', '01605227', >> '01605228') >> >> Am I correct in my understanding of what is happening? >> >> Is there any way to avoid this extra fetching of the records to get >> information that the server already has? This adds significantly to the >> time needed to produce the results. >> >> >> ARS 7.6.03 >> Mid-tier 7.6.04 >> Solaris 10 >> Oracle 11.2.0... >> >> Thanks for any insights. >> Larry >> >> Larry Robinson >> Remedy Developer / Admin >> NC State University _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
