Share
ReportI can't say that the payables HTB report ahs been all that fast but it is taking an hour or so to run. Users are not thrilled and want it faster. I am not sure where to start or if there is a routine that we are not running that should be to clear out transactions or something.
If I run "select count (docnumber) from PM00400" I get about 2mil records. The sql server seems to not be under a large load so I suspect that the hardware can handle the load.
What should I try and are there any routines that could be tried. This is available in a test environment so I can do just about anything. The issue occurs in test and in production systems.
Thanks for any help, correction any useful help. LOL
*This post is locked for comments
All responses (
Answers (
292,516
