|
My suggestion goes by the side of the data base. If this to your reach to modify the stored procedure, or the design of the data base,
(I either do not have idea of the logical design of the data base ) but first I suggest to you you could not be denormalize the data base with the purpose of improving the times of the consultation.
Perhaps you should have tables with some totals already calculated. You could update the tables “automatically” with triggers on the INSERT/DELETE/UPDATE the present tables of querys. This is going to make a little bit slower the update of the tables, but you can improve the times of the consultations.
Which is your motor of data base?
Felissa
|