Hi,
A call to a web-service get-list search does not trigger filters. In other
words, it can not trigger a filter that returns anything. Or did I miss
your point?
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,
>
> 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"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
