We are looking in to using websphere dynacache to cache a data structure that we build from the results of a db query. The data base tables are updated about every 5 minutes or so and we want to rerun the query and re-cache the data at about the same time the db is updated. A small table exists that stores the timestamp of the last time an update was made. What options are available to invalidate the cached data using this configuration?
We were thinking we could poll that table every 30 seconds or so and see if the time stamp has changed since the last time the data was cached. But I have not used dynacache before and from what I've read so far I don't know how to make it work the way we would like it to. Any suggestions?