Performance Issue Analysis of Validation API

• The Ingest Customer process will perform validations during customer creation or update before persisting the data into the table.
• During these validations, the process will call the Reference Data API and cache all static data.
• For certain validations, such as country rule set and tax validations, there is static data defined in the table.
• This static data needs to be cached in the Ingest Customer process as well.

Somehow, caching is not working as expected for certain static data, such as the country rule set and tax validations. As a result, the validation API is taking more than 5 seconds to validate each customer.

Customer Code	Validation Start Time	Validation End Time	Total Time(secs)
SA50005194			2.200sec
IN02964772			5.100sec

Attached the Reference Logs:

Based on the analysis of the logs every time we observed that its calling Database for each country rule set validation as below

SPT Results Before Fix:

SPT Results After Fixing Cache Issue:

Validation API Flow: