Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

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?

0
Posted

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?

0

Location: http://www.jguru.com/faq/view.jsp?EID=219669 Created: Sep 30, 2000 Modified: 2000-09-30 19:21:55.207 Author: Joe Sam Shirah (http://www.jguru.com/guru/viewbio.jsp?EID=42100) Question originally posed by Vinod Tadepalli (http://www.jguru.com/guru/viewbio.jsp?EID=19366 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.

Related Questions

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.

Experts123