Options

Queuing Reports ?

burguetjfburguetjf Member Posts: 2
Hi everyone

Has anyone tried to implement a report queue to improve system performances ? Just like a shared network printer has a queue, I am thinking about the same concept to manage heavy reports.

If report A and report B are very processing intensive and need to work on the same data, the total running time to finish report A + report B is smaller if they are ran one after the other, no ?

Because of our business cycle, many of our Navision Attain 3.7 users need to launch very heavy reports on the same two or three days of the months. Our system (which works fine with 150 concurrent users during the rest of the month) obviously becomes extremely slow.

When our system becomes slow, everyone has to wait without knowing how long to wait. Managing users expectations is of course another of my goals. A nicely implemented queue could show them which/whose reports is waiting in the queue in front of theirs.

A further raffinement could allow a finetuning: how many reports can actually start running in parallel. Just one during busy times, more during calmer days...

We are already using a second server with a copy of the DB to run those heavy reports which are OK with yesterday's data. We need a solution for those reports running on "fresh" data from our main system.

We just started our reflexion, wondering if running the scheduler on a separate PC might the be the way to manage the queue.

Your ideas or suggestions would be most welcome. Thanks a lot !

Comments

Sign In or Register to comment.