Hi,
I have enabled FIFO caching for a table. The first time I retrieve records
using a criteria, it stores them in the cache. The next time I use the
criteria, I get the result from the cache. Then I modify those records - not
through the data object that was returned to me by the cache though. How do I
make sure that the cache is in sync? If I mark - purge the cache on inserts -,
its going to remove even the records that needn't be removed.
Another question I have is regarding the scope of the cache. Is it the same
cache thats available across the application for a table or is it limited to a
connection or some other scope?
Thanks,
Anurag