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

Cache SQL (or closer precursors to SQL) more aggressively

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 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.2.0
    • jdbc, kernel, query, sql
    • 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 W. Sutter
        4. OPENJPA-407.patch
          81 kB
          Jeremy Bauer
        5. OPENJPA-407.patch
          80 kB
          Fay Wang
        6. findBy.patch
          10 kB
          Kevin W. Sutter

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: