Best practices to improve performance in MII transaction

[former_member191528]

Hello All,

I would really appreciate if you all could list the best practices to improve performance of MII transaction. We have a scenario where we are calling queries to historians systems at the manufacturing floor which are distributed across the globe and we wanted to make sure we deliver the best performance through our transactions. Also performance of For Loop V/s a Repeater for same senarios ?

Thanks,

Kiran

[Former Member]

Hi Kiran,

what helps us most to improve performance in MII:

- use XPath functionality whenever possible (e.g. addressing specific values in an result XML from a query)

- reduce database calls - for example by ready a complete set of lines and extract specific values using XPath

- filter For loops - use XPath in the for loop configuration to reduce loop number

- let the database work for you - e.g. we use Oracle with XSU ([XML SQL Utility|http://docs.oracle.com/cd/B10501_01/appdev.920/a96621/adx23xsp.htm]) for bulk changes

Those are just a few thoughts.

Regards

Michael

[Former Member]

Hi

In addition to what Anshul has said

Some of the most General Best Practice to improve your Transactions are:

1) Always use the java version specifically mentioned for your MII version.

2) Always use PARAM, if you are using session variables (hard code only for testing purpose).

3) Use Trace Action Block for debugging

4) Use a Standard naming convention.

5) Use separate folder hierarchy for your Project.

Regards

Sweety

[Former Member]

Hi Kiran,

You can find all the guidelines here

https://wiki.sdn.sap.com/wiki/display/xMII/Guidelines

Specially check for

SAP MII Best Practice Guide for 12.x

https://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/f08d7ae2-6f56-2c10-50b4-8a3bb1d43502

Some other useful links:

Optimizing Business Logic Transactions with XPath

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/e339015e-0b01-0010-a4b8-f35ed792273b

With Xpath you can improve performance of repeater.

Tips and Tricks for Building ERP Interfaces in MII

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/b0f26203-5ebd-2b10-5cb4-84e7019bfadc

Thanks

Anshul