Temporary table and memory usage when printing reports

Alex_Chow

Hi, on the A/R aging report, when a lot of records are being inserted into the temporary table, it takes up all of the CPU and memory on the service tier causing slowdown across the board.

Will remove the data in the temporary table address this? Or does one of the hotfixes address this?

This is for NAV 2013.

davmac1

When someone has a slow aging report, I usually do a mod to address it.
One mod is to check the customer balance using flowfields and bypass everyone with a zero balance. If accompany has a huge number of customers with a small % active at any one time, that can save a lot of time.
If the problem is caused by their customers having a huge number of transactions, then some code to filter out the transactions being processed could work too - for example only look at open entries - downside, the closing date is not updated for all entries, so without a posting mod, this will give you point in time only.

Alex_Chow

Thanks for the response!

Yes, the A/R report is the one I'm troubleshooting. However, for any other reports where Excel buffer is used as temporary table, any work arounds or hotfixes that will address the memory issue?