Use of session cached non-persistent entity

0
The objects in my app have a large number of FKs which link to persistent objectss with 1000+ entries. Mindful of permance it was my idea to use non-persistent entity/NPE {virtual tables} which would store the entries,  loading from the appropriate source, when an db object was retrieved, the list of entries for the various selector component/widgets could be populated from the NPEs. I have read that NPE can be linked/assigned to the Session object to cache them. What I haven't found is a description of who I might be able to reload the NPE is I was able to determine that a change to the underlying db table/persistent entity,  detected via notification from a Kafka topic, or some other check of db via timed workflow/microflow. Is my approach possible?  Is there a better approach? Thanks 8n advance  
asked
0 answers