Performance Tuning of High Volume PO Process

Balakrishna Reddy Duvvuru – For a leading American retailer of aftermarket automotive parts and accessories, Hexaware’s team identified a custom process in PeopleSoft that was running long, with high volumes of invoice data and was getting stuck in between. The team had to run each file, one by one, resulting in a heavy manual effort of 18 hours to load all files.
Balakrishna identified long-running process logic in the program and carried out performance tuning of SQL and indexing of the tables. This dramatically resulted in 13 minutes of change implementation process for the same data load, which earlier used to take 260 minutes in production.