Malcolm,
Cayenne already supports this via query caching. Check
SelectQuery.setCachePolicy(..). The policy can be either of
QueryMetadata.LOCAL_CACHE, QueryMetadata.LOCAL_CACHE_REFRESH,
QueryMetadata.SHARED_CACHE, QueryMetadata.SHARED_CACHE_REFRESH (should
probably define them as enums in 3.0).
Andrus
On Nov 27, 2007, at 11:58 PM, Malcolm Edgar (JIRA) wrote:
> Support Entity/Table scope caching
> ----------------------------------
>
> Key: CAY-925
> URL: https://issues.apache.org/cayenne/browse/CAY-925
> Project: Cayenne
> Issue Type: New Feature
> Components: Cayenne Core Library, CayenneModeler GUI
> Affects Versions: 3.0
> Reporter: Malcolm Edgar
> Assignee: Andrus Adamchik
>
>
> On most of our projects we do not use caching, because of the size
> of the databases, and or issues of multiple applications writing to
> the database. However one feature we would really like is to be
> able to specify that individual tables/entities are cached in memory
> by Cayenne.
>
> This is typically for UI lookup values which change very
> infrequently, or deployment properties which also change
> infrequently. By caching this information in memory we can
> significantly reduce the number of requests made to the database and
> improve application performance.
>
> --
> This message is automatically generated by JIRA.
> -
> You can reply to this email to add a comment to the issue online.
>
>
This archive was generated by hypermail 2.0.0 : Wed Nov 28 2007 - 04:48:09 EST