Skip to main content

Transaction speeds for large SKU base


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)?

Thanks.

Did this topic help you find an answer to your question?

4 replies

Troy Vars
Semi-Pro I
Forum|alt.badge.img+2
  • Semi-Pro I
  • 54 replies
  • August 24, 2023

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. 


  • Author
  • Freshman I
  • 2 replies
  • August 24, 2023

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


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2640 replies
  • August 24, 2023

Closing this one as duplicate post here: 

 


  • Author
  • Freshman I
  • 2 replies
  • August 24, 2023

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings