As a legacy of a prior configuration our instance has 1,000,000’s of customers which were used one time, and now sit there slowing down the system.
If we set these to inactive should we expect a speed/performance benefit around the sales order/AR screens that reference customer? Currently it takes an eternity to load/search for customers
Solved
Are there system performance benefits to setting records to inactive?
Best answer by darylbowman
I think it depends when you're seeing slowness. Most selectors filter out inactive records, so if it's picking a customer that's slow, that could help. You can configure the primary GIs not to show inactive accounts, or at least set the default filter to exclude them. That should help loading the Customers GI.
Regardless, the system queries will brush those records sometimes. It can't really be prevented. But yes, there are things that should help.
+13I think it depends when you're seeing slowness. Most selectors filter out inactive records, so if it's picking a customer that's slow, that could help. You can configure the primary GIs not to show inactive accounts, or at least set the default filter to exclude them. That should help loading the Customers GI.
Regardless, the system queries will brush those records sometimes. It can't really be prevented. But yes, there are things that should help.
Daryl ⚡Contract Acumatica Developer (MVP🏆) for hire ⏩ linkedin.com/in/darylbowman
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.