Home › Discussions › Questions & Answers › Inventory Item Import Performance Degradation

Inventory Item Import Performance Degradation

Avatar photoCustomer Questions & Answers 5 replies

We are seeing that our background processes for loading inventory items are getting slower over time. The processing rate decreases as the total number of items processed increases. How can Blitz Report help diagnose this trend?

5 replies

  • Support Enginatics

    The INV Item Import Performance report is specifically designed to be an analytical report to predict the performance of inventory item load background processes.

  • Avatar photoCustomer

    What does the report analyze to point to the root cause of this performance decrease?

  • Support Enginatics

    If the number of items processed per second decreases as the total items processed increases, the report indicates that the interface SQLs are most likely using a wrong nonselective index, and corrective action should be taken to fix the SQL.

  • Avatar photoCustomer

    If the slow SQL is identified, what is the recommended next step?

  • Support Enginatics

    Once identified, the SQL should be analyzed and corrected, usually by reviewing the execution plan (using reports like DBA SGA SQL Execution Plan History) and ensuring indexes are appropriately used to avoid nonselective reads.

  • You must be logged in to reply to this post.