Is cacheing the result set really what you want? I know on web-based systems, I'd prefer to cache at the page level (or even a component level).

If it's an oracle database (PL/SQL), I think I'd let Oracle cache through decent SGA settings (caveat - I'm not a dba). Is the network traffic really a bottle neck anymore?

-derby