FAQ
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.

Search Discussions

  • Andrus Adamchik at Nov 28, 2007 at 9:48 am
    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.
  • Anonymous at Nov 29, 2007 at 10:05 am
    [ https://issues.apache.org/cayenne/browse/CAY-925?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

    Malcolm Edgar closed CAY-925.
    -----------------------------

    Resolution: Fixed

    Currently supported via Level 2 caching and query caching policies.

    Level 2 (local VM) caching enabled, and then set caching policy as appropriate for the query:

    // For most of the queries
    QueryMetadata.LOCAL_CACHE

    // For cached lookup data
    QueryMetadata.SHARED_CACHE
    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.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupdev @
categoriescayenne
postedNov 27, '07 at 9:59p
activeNov 29, '07 at 10:05a
posts3
users2
websitecayenne.apache.org

2 users in discussion

Anonymous: 2 posts Andrus Adamchik: 1 post

People

Translate

site design / logo © 2022 Grokbase