How to cache rarely changed many-to-one entity in CF ORM?

Question

How to cache rarely changed many-to-one entity in CF ORM, such as, userType where there are only < 10 types? I don't want the extra select to get the type name.

EhCache? Any XML needed to be config first? Any thing I need to add in the many-to-one cfproperty?

Thank you.

Answer 1

Add this to your many-to-many to force it to load the children when populating the entity.

   lazy="false"

Answer 2

If UserType is a component, you specify cacheuse="read-only" cachename="UserType" in the component definition. read-only is the fastest and is good for cases such as the one you describe.

In my experience, simply specifying the cache value on the property in the owning component did not cause the caching that you'd expect... I needed to specify it directly on the component-being-cached

Because you're using read-only for speed, you'll need something somewhere to let you evict that cache when data are updated:

ormEvictEntity("UserType");