I have a problem retrieving data from an Oracle db with any kind of reasonable speed. Right now I&#039m using an OLE DB connection to the db, but it seems to take an extraordinary amount of time. I have some ideas for optimizing my query, but what I&#039d like to know are some ways to cache or buffer that piece of data for all users for a specific time period, say an hour. Any help appreciated. Any idea whether that would be better or worse than say, using a snapshot of the database instead?