Any frameworks anyone can suggest for this?
Say my app runs this
After it's done the heavy lifting over the wire from the DB, I want to cache this on my Application server (In memory) and then when a query with exactly the same predicate comes along, my app can go "tadaaaaa" without having to do a fresh DB fetch.Code:SELECT BigFatMahoosiveBlob FROM BigFatTable WHERE Predicate = xyz
Usual expiration stuff etc.
So, what does the panel recommend?
For bonus points, is there anything where the DB can ping back a message to say you're data is stale now?