[OPENJPA-407] Cache SQL (or closer precursors to SQL) more aggressively

• 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
• Assignee: Fay Wang
• Reporter: Patrick Linskey
• Created: 17/Oct/07 17:49
• Updated: 21/Sep/16 14:21
• Resolved: 15/Jul/08 19:36

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.

Issue Links

• is related to: OPENJPA-703 Cache ResultObjectProvider data to improve query performance
• relates to: OPENJPA-2121 Determine proper configuration of SQL caches
• relates to: OPENJPA-2099 Reuse relationship selection