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 ?
Can anyone please help me ?