[
https://issues.apache.org/jira/browse/OPENJPA-407?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12535765
]
Patrick Linskey commented on OPENJPA-407:
-----------------------------------------
In case you're interested, my numbers are based on running the full OpenJPA
test suite on the same hardware, with and without the changes. Without them
(clean trunk build), the JDBC tests take around 7.5 minutes, and I just got a
run in 5.5 minutes with the attached patch + my SQLBuffer prototype.
This is a significant speedup, especially considering that our tests generally
probably don't reuse statements as much as the average database application,
since we generate a lot of different SQL and don't generally do the same thing
too many times.
> Cache SQL (or closer precursors to SQL) more aggressively
> ---------------------------------------------------------
>
> Key: OPENJPA-407
> URL: https://issues.apache.org/jira/browse/OPENJPA-407
> Project: OpenJPA
> Issue Type: Improvement
> Components: jdbc, kernel, query, sql
> Affects Versions: 0.9.0, 0.9.6, 0.9.7, 1.0.0
> Reporter: Patrick Linskey
> Fix For: 1.1.0
>
> Attachments: OPENJPA-407.patch
>
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
