You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Kevin Sutter (Created) (JIRA)" <ji...@apache.org> on 2012/02/07 20:16:59 UTC

[jira] [Created] (OPENJPA-2121) Determine proper configuration of SQL caches

Determine proper configuration of SQL caches
--------------------------------------------

                 Key: OPENJPA-2121
                 URL: https://issues.apache.org/jira/browse/OPENJPA-2121
             Project: OpenJPA
          Issue Type: Improvement
          Components: jdbc, query, sql
    Affects Versions: 2.3.0
            Reporter: Kevin Sutter


With the introduction of the openjpa.jdbc.CachesSelect (openjpa-2099) property, we now have three configuration properties that relate to the caching of the generated SQL.  These properties are not consistent with their default values, the documentation, and configuration.  We should make these consistent.

The three properties are:

openjpa.jdbc.QuerySQLCache - SQL generated from JPQL cache
openjpa.jdbc.FinderCache - FindBy SQL cache
openjpa.jdbc.CachesSelect (openjpa-2099) - SQL used for collection loading cache

The default values for QuerySQLCache and FinderCache are true, while the default value for the CachesSelect is false.

QuerySQLCache and (eventually) CachesSelect are documented.  FinderCache is not documented.

As far as I can tell, QuerySQLCache and CachesSelect are actively being checked for and utilized in conditionals -- that is, the setting of these properties affect the caching of the generated SQL.  I can't find the same processing for FinderCache.

Even the names of these caching properties are not consistent.  At a minimum, it would be nice to re-name CachesSelect to something like CollectionSQLCache.  An even more radical approach would be to combine the setting of these caches into a single property with multiple attributes.  Something like:

openjpa.jdbc.PreparedSQLCache (querySQLCache = true|false, finderCache = true|false, CollectionSQLCache = true|false, <any other necessary attributes>)

Just an idea.  Bottom line is to get these generated sql caches consistent from a configuration, usage, and documentation viewpoint.


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira