Issue with OCC data mapper

[pachoudhary]

Hi All,

The data mapper is taking too long to convert the data to DTO and give the response back. This is happening only the first time an API is called, and then it responds very quickly.

Let me know if anyone has faced the same.

[adiputera]

Second call likely coming from cache.

Did you have a lot of attributes to map?

So call to database was quick, converter and populator was also quick, only the data mapper having some issue?

[pachoudhary]

yes, database call is quick. Only when data mapper create a cache in MapperFacadeImpl it takes longer time and then the response id fast.

[alemasetto]

Are you sure the issue is at mapper level? What if you open Dynatrace -> distributed traces and verify every step behind that call? Perhaps there is another bottleneck.

If the issue is at datamapper level, try to optimize the data mapping process to make it more efficient, for example by reducing the amount of data being processed. For instance, map only the values you need (by means of "fields" query param) instead of fields=FULL
Tip: Try to manually call the API (with curl or another client) and test each single field; verify if you always see the latency or just for specific values.
Check also your populators (Model -> Data), are they fast as expected?

SAP Commerce Cloud uses Orika, check also this page https://orika-mapper.github.io/orika-docs/performance-tuning.html

[pachoudhary]

Hi Alessandro,

I checked Dynatrace and below is the stack trace for the same. Some how thread execution when mapper class is called for the first time is taking time.