Transaction speeds for large SKU base

  • 24 August 2023
  • 4 replies

Has anyone experienced decreased overall operational speed with a large data set of >500 SKUs (i.e., is there inverse relationship between operational speed and SKU quantity in a system)?


4 replies

Userlevel 4
Badge +2

We have several clients with 5000+ sku for inventory. With no noticeable degradation in performance.

The only exception was one client had large Sales Orders with more than 500 lines. This seems to be more of an issue than the number of Sku’s in the database. Somewhere we heard about a method to limit how many lines load at a time on the Details tab but we never implemented it. The client decided to split these large orders instead and group bill the shipments on the invoice later. 

Thank you, Troy.  I meant 500,000 SKUs.  Sorry.

Userlevel 7

Closing this one as duplicate post here: 


The repost is the correct post.  The posting “Transaction speeds for large SKU base” is wrong.  


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved