I'm using a version of JDO for this. IBM offers "Data Access Beans" with Websphere which are basically a JDO implementation (Castor would do the same thing for other app servers). I execute the query from a SLSB using a DAO which populates the access bean. When close() is called on the SelectResult class of the access bean, it effectively acts like a cache and seems to perform fairly well.
This is a scenario where the user is accessing the cache as a workspace via COM/Excel so access to all the records is imperative. They want to bring up the data and do all kinds of sorting, etc. with it. I don't claim this makes sense for all apps but it is working in this case. >From: Alex Paransky <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: [EMAIL PROTECTED] >Subject: Re: result stepping >Date: Fri, 2 Nov 2001 01:36:10 -0800 > >There are a number of views on this issue: > >1) Avoid the issue. Sure, it's nice to be able to scroll through thousands >of items, however, how is this adding value to the user? What use case is >this satisfying? To avoid this, perhaps a classification for the items >needs to be designed and a tree-like navigation created to allow user to >navigate to the proper set of items. > >2) Another way might be to execute the ejbFind but store the resulting >collection in a state full session bean. Then get more items from the >state >full session bean as the user is scrolling up or down. A smart EJB >container will not try to load thousands of items that you have found in >ejbFind unless you attempt to specifically access that item. Even then, >not >all the items can be kept in memory due to memory limitations. Assuming >you >are not in a transaction (you might have problems using state full session >bean in a transaction when it comes to finally remove) the container can >unload those beans which are not being used. > >3) Finally, you can go directly to the database and avoid the Entity beans >altogether. > >I am interested in what others have to say on this issue. > >-AP_ > _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help".
