Counts and sums are expensive operations when large tables are involved. I have several that are well over a million rows and performing these counts and sums on the fly is very slow.
I need the results in both the front end as information to the user, and in the back end for logic.
The common thinking on this is to save the results to a table, cache or other memory. Can anyone point me in the direction of the best way to get this setup, or if there is a package available? I think I need...
Or maybe I am going completely the wrong direction on this and there is a better way?
Thanks a lot.