Keeping query result sets in server memory can provide a significant performance enhancement for supporting a high volume of repetitive data access, but how can this functionality be implemented?

Joe Sam Shirah

Some initial considerations are sufficient memory to hold the data and possible periodic refreshes. For the actual implementation you can use arrays, vectors or a Collection, but the most blessed way at the moment is to implement or use a third party implementation of Rowset. Javasoft has an Early Access JDBC(tm) Rowset implementation at the Java Developer Connection. Note that you must be a member to download the classes.