Second level cache - how does it work

Hi. Trying to understand how does level 2 cache (with default cache implementation) work in Lightspeed, but I can not from the current available resources. I understand how to enable it, but details of operations are unclear to me.

When is the entity stored in cache? Is it after it has been fetched from DB with any type of query (i.e. within a list of entities)?
When will the entity be refetched from cache without a query to DB? I expect only in case of a making a query with single ID in where condition (or possibly only when calling Uow.FindOne(id) method). I guess that as long as I have any other type of where condition (even if it is repeating all the time), query must be sent to the DB anyway. Or are possibly also queries stored in cache (like I see in some other ORM's documentation)?

Some feedback with exact rules would be appreciated. Thanks.

Hi Marko,

Rather than respond here, JD has published a blog post that provides a detailed survey of level 2 caching -- some of it will already be familiar to you but hopefully it will answer your questions.

The one thing you asked about that isn't mentioned there is query caching.  At the moment LightSpeed doesn't cache queries: the cache is used only to hold entities.

Please follow up if you have any more questions!