Uploaded image for project: 'OpenJPA'
  1. OpenJPA
  2. OPENJPA-407

Cache SQL (or closer precursors to SQL) more aggressively

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: 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
    • 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.

        Attachments

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

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: