Hello Folks, I have some requirements on CacheLoader for cache miss events.
>From the geode docs, The loader is called on *cache misses during get operations*, and it populates the cache with the new entry value in addition to returning the value to the calling thread. *Region* Employee [Type = Replicated , Primary Key = employeeId] *Indexes**:* Employee.employeeId Employee.ssn *Notes*: I have only 100K employees as preloaded in cache initially. [Assume I have a purpose not to load everything just to save memory] *Case1:* User fires a query say, select a from /Employee a where a.ssn = 'testssn' *Q1: * Is it possible to load employee based on *ssn* parameter if it's missing in cache? [SSN is unique for Employee -- So 1 entry exists in database] *Case2: [I know this does not match to purpose of cache loader, but any suggestion to achieve same by any means ?]* User fires a query say, select a from /Employee a where a.salary > 100000 *Q2:* Is it possible to load employee based on salary parameter if it's missing in cache? [Such queries should bring all employees with salary > 100K from database] Thanks, Parin