1 Reply Latest reply: Jul 17, 2012 1:55 PM by Misi Mladoniczky RSS

    web service question

    dc NameToUpdate

      We have a requirement where we need to pull data from multiple tables of a DB2 database.

      The customer wants the real-time data & so we are proposing a web service to be published by the DB2 DBAs which remedy can consume.

       

      The target tables contain 8-10 million records altogether & we need to fetch only one record at a time (To be specific - on click of a button, call the web service which will search one record with help of a join query of the multiple DB2 tables)

       

      The question I have is, is web service an optimal option in this case where we are going to query large tables?

       

      Thanks

        • 1. web service question
          Misi Mladoniczky

          Hi,

           

          The table size is not the issue here.

           

          The important thing is that you ar retrieving one record at a time.


          This would make it very efficient to do from a Remedy standpoint.

           

          ACTL on Button

            Action:

              Service Call:

              --> input

              FLTR on Service

                Action

                  Set-Fields: from WebService

              <-- ouput

           

          And it is also important that the DB2 people can design an efficient join behind the WebService. But that problem would be the same regardless of technology.

           

                  Best Regards - Misi, RRR AB, http://rrr.se