Within our system a user gets credit for activity on the platform
(for example bboard participation). This and some other criteria lead
into a ranking of the users. Such a query would be very slow if you
have a lot of users and even slower if you wanted to show the result
on quite some pages...
Is there any code inside openacs that performs a complex query once
every hour or so, saves it in a different table and gives it out to
the user whenever he wishes? And how do I use it?
Is there any other way to do this kind of job?