MAM30_070 performance issue

[Former Member]

Hello,

We have serious performance problems between middleware and backend.

The selection of the inventory takes 70sec for 1 sync.... This is way too much.

For the selection of the inventory we have 4800 entries in MAM30_070_GETLIST.

I wrote a little testprogram to measuer the time needed for selection:

*&---------------------------------------------------------------------*
*& Report  ZJVB_TEST_MAM30_070
*&
*&---------------------------------------------------------------------*
*&
*&
*&---------------------------------------------------------------------*

REPORT  ZJVB_TEST_MAM30_070.

data: itab type TABLE OF MAM_30_INVENTORY_MNG_ITEM,
      wa like LINE OF itab,
      g_start type i,g_end type i,g_start_2 type i,
      g_aantal type i,
      g_detail type i,
      w_counter type i.

get RUN TIME FIELD g_start.

CALL FUNCTION 'MAM30_070_GETLIST'
 EXPORTING
   USER                 = 'CRMJV'
 TABLES
   INVENTORY_LIST       = itab
*   RETURN               =
          .

get RUN TIME FIELD g_start_2.
describe TABLE itab LINES g_aantal.

LOOP AT itab INTO wa .
  CALL FUNCTION 'MAM30_070_GETDETAIL'
    EXPORTING
      USER                 = 'CRMJV'
      MATERIAL             = wa-material
      SERIALNO             = wa-serialno
      EQUIPMENT            = wa-equipment
*   IMPORTING
*     INVENTORY_ITEM       =
*   TABLES
*     CE_INVENTORY         =
*     RETURN               =
*     WSAP_EXTENSION       =
            .
  add 1 to w_counter.
ENDLOOP.

get RUN TIME FIELD g_end.

write:/ 'Start:', g_start.
write:/ 'Na getlist:' , g_start_2.
write:/ 'Aantal watermeters:', g_aantal.

write:/.

write:/ 'Na getdetail:', g_end.
g_detail = g_end - g_start_2.
write:/ 'Tijd nodig voor selectie detail:', g_detail.

To my surprise in the backend the program only runs 10sec. Where are the other 60sec used for? What can I tune?

Kind regards,

jeroen

[Former Member · Accepted solution]

Hello Jeroen,

Basically MI has to do a delta check from the data it just received from the backend and the data available on the device.

I don't see any ways of improving that time (apart from reducing the number of entries). Maybe MI guys can help you on that.

From my stand point, it seems that 4800 materials for a day of work for a technician is quite a bit. Maybe you should have a look with you business process expert to reduce that number of material that will actually be used in real life scenario. You can do that by adjusting the variant in the backend customizing.

Thank you,

Julien.

[former_member304703 · Accepted solution]

Hi Jeroen,

You might want as well to take a look at the document "Data Download Supression"

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/webcontent/uuid/c078b0fd-1282-2910-b5b3-89f67... [original link is broken]

Technique described there allow mobile user to control when to download SyncBo.

Cheers,

Larissa Limarova