Re: Cache

Rgiri-

Depending on what framework you are using for persistence, I would look @ what it supports. E.g. We use hibernate & have set up the level 2 cache appropriately for our read-only tables. Weblogic allows you to configure CMP beans to be read-only and if set will cache them in the app server tier. I'm sure other persistence frameworks have equivalent solutions to this problem.

-pgm

From: An interest list for Sun Java Center J2EE Pattern Catalog [mailto:J2EEPATTERNS-INTEREST@JAVA.SUN.COM] On Behalf Of Rumpa Giri
Sent: Wednesday, June 22, 2005 3:01 PM
To: J2EEPATTERNS-INTEREST@JAVA.SUN.COM
Subject: Cache

Hello,

I would like to know what will be a good way to implement the following:

We have many read only tables in the database. I was thinking rather than doing a select all from the table all the time, we would like to keep the collection of objects in memory to reduce the database traffic. The SQLs for this is pretty much SELECT * FROM TABLENAME. No filtering is present. And this collection of objects is referenced too many times.

Any related articles, pointer will help us.

Thanks,

Rgiri.

Yahoo! Mail Mobile
Take Yahoo! Mail with you! Check email on your mobile phone. ==================================================================== Companion Site: http://www.corej2eepatterns.com J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns List Archive: http://archives.java.sun.com/archives/j2eepatterns-interest.html Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to listserv@java.sun.com

==================================================================== Companion Site: http://www.corej2eepatterns.com J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns List Archive: http://archives.java.sun.com/archives/j2eepatterns-interest.html Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to listserv@java.sun.com

Re: Cache

McKinstry, Pete (HQP)

2005-06-30