|
If you have access to the data base, you can denormalize the design of the logical structure of the data base.
if the Stored Procedures runs weekly, I suppose that it is batch… isn't it?
You could leave the results in temporary tables, and what it is consulted they are these temporary tables, that become to be above every week.
The bad thing of this you have the information one week late; although depending on the necessities of the logic of the business, could be acceptable.
Greetings,
Eric
|