Forum OpenACS Q&A: Re: How do I cache a big database request?

Posted by Peter Marklund on
you can use util_memoize in conjunction with util_multirow_to_list (to stuff query result in the cache) and util_list_to_multirow (to reconstruct the multirow) see this thread:

Basically what I did was I created a proc that returns the list  representation of the query result, wrapped that proc in util_memoize and then applied util_list_to_multirow to get the multirow back.

For cache control, see /acs-admin/cache.