Skip to main content

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

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.


Reply