OpenJPA
  1. OpenJPA
  2. OPENJPA-407

Cache SQL (or closer precursors to SQL) more aggressively

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 0.9.0, 0.9.6, 0.9.7, 1.0.0, 1.0.1, 1.0.2, 1.0.3, 1.0.4, 1.1.0, 1.1.1
    • Fix Version/s: 1.2.0
    • Component/s: jdbc, kernel, query, sql
    • Labels:
      None

      Description

      When data is not available in the data cache, OpenJPA dynamically creates SQL to look up the requested data. OpenJPA should more aggressively cache this SQL to accelerate pathways from a cache miss to the database.

      The generated SQL takes a number of factors into account, including the requested records, transaction status, currently-loaded data, and the current fetch configuration. Any caching would need to account for these factors as well.

      1. OPENJPA-407.patch
        80 kB
        Fay Wang
      2. QuerySQLCache.doc
        63 kB
        Jeremy Bauer
      3. OPENJPA-407.patch
        81 kB
        Jeremy Bauer
      4. OPENJPA-407.patch
        55 kB
        Kevin Sutter
      5. findBy.patch
        10 kB
        Kevin Sutter
      6. OPENJPA-407.patch
        66 kB
        Patrick Linskey

        Issue Links

          Activity

          Patrick Linskey created issue -
          Patrick Linskey made changes -
          Field Original Value New Value
          Attachment OPENJPA-407.patch [ 12367896 ]
          Kevin Sutter made changes -
          Attachment findBy.patch [ 12374420 ]
          Kevin Sutter made changes -
          Attachment openjpa-407.patch [ 12378725 ]
          Kevin Sutter made changes -
          Attachment OPENJPA-407.patch [ 12378726 ]
          Kevin Sutter made changes -
          Attachment openjpa-407.patch [ 12378725 ]
          Jeremy Bauer made changes -
          Attachment OPENJPA-407.patch [ 12380863 ]
          Jeremy Bauer made changes -
          Attachment QuerySQLCache.doc [ 12380864 ]
          Fay Wang made changes -
          Attachment OPENJPA-407.patch [ 12381066 ]
          Patrick Linskey made changes -
          Fix Version/s 1.1.0 [ 12312344 ]
          Fix Version/s 1.1.1 [ 12313177 ]
          Kevin Sutter made changes -
          Affects Version/s 1.1.0 [ 12312344 ]
          Fix Version/s 1.2.0 [ 12313102 ]
          Affects Version/s 1.1.1 [ 12313177 ]
          Affects Version/s 1.0.3 [ 12312969 ]
          Affects Version/s 1.0.1 [ 12312687 ]
          Affects Version/s 1.0.2 [ 12312846 ]
          Affects Version/s 1.0.4 [ 12313301 ]
          Kevin Sutter made changes -
          Assignee Fay Wang [ faywang ]
          Fix Version/s 1.1.1 [ 12313177 ]
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Resolved [ 5 ]
          Ron Pressler made changes -
          Link This issue is related to OPENJPA-703 [ OPENJPA-703 ]
          Donald Woods made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Kevin Sutter made changes -
          Link This issue relates to OPENJPA-2099 [ OPENJPA-2099 ]
          Kevin Sutter made changes -
          Link This issue relates to OPENJPA-2121 [ OPENJPA-2121 ]

            People

            • Assignee:
              Fay Wang
              Reporter:
              Patrick Linskey
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development