We have a large amount of data that rarely changes that needs to be accessed through our web site. Currently, the data is queried via
JDBC everytime someone wants to look at it, but some of the queries can take a long time. We are now in the process of coming up with a design to cache the data in memory and retrieve it from there, with a background process running to update the cache in the event that the database data does change.
Has anybody tried to implement the Lifetime-In-Cache with entity beans that WebSphere 5 provides?
If so, what were the results on performance, response times, etc.?
Would it be better/easier to simply cache the data in memory using POJO's or some other "tool" (OS Cache?)?
Any help would be appreciated.
Thanks.
Eric