Performance

These are just ideas from a few of us loons. We realize performance may take a hit, but we see a lot of repeat reporting in our locations where we woudl see VAST improvement.

Example 3. We All Need The Same Data

10 directors all want the same report. If we did in a client they all 10 hit the database for the report. (which is a large consolidation so rather intense).

The alternative is to pre-print the report and hand to each of them. This model woudl allow us to batch said reports and create static html for online viewing and other formats for printing if need be. We can then save these if we want for archivals. Thus instead of 10 intense queries we have 1 intense query that happens in the middle of the night in off peak hours.