Skip to Content
Apr 25, 2017 at 11:12 PM

How to invalidate a Query cache?



I have a number of web requests running at a time to access some DB values. Each transaction invokes the DB once and also updates the value.

All the requests are running almost in-parallel (though requests sent one by one, but processed very fast). I noticed that I was not getting the updated value from DB; means the query cache was not invalidated properly.

Is there a way to invalidate the query cache ; such that I could get the latest value which was recently updated by another request?

I see following statement which could be the root cause of my problem but I am looking for the solution :-( "There are circumstances where the invalidation is delayed, for example when working with transactions. By default, entries modified inside a transaction are invalidated after the transaction."

Thanks, Abhishek