Cust Aging report processing time improvement

Hi All,

One of my client is using AX 2009 and they have customer aging report which runs on every month end. There is a batch job which schedules for that.

It currently takes 15 -16 hours to complete the full execution of report. 

Once I started digging into it, I found that in fetch method where the query is fetching the records (Qr.next()), the total records fetched using that query are 15737358 (close to 16 million).

I already checked the indexes and there is nothing much found in that.

Is there any way where I can do some performance improvement (speed up the  time)  or does it look Ok this much time to process (close to 16 million) records ?

Please suggest.

Regards

Parents
No Data
Reply Children
No Data
Related
Recommended