From dev-return-6483-apmail-openjpa-dev-archive=openjpa.apache.org@openjpa.apache.org Wed Oct 17 17:58:23 2007 Return-Path: Delivered-To: apmail-openjpa-dev-archive@www.apache.org Received: (qmail 18317 invoked from network); 17 Oct 2007 17:58:22 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 17 Oct 2007 17:58:22 -0000 Received: (qmail 61455 invoked by uid 500); 17 Oct 2007 17:52:29 -0000 Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org Received: (qmail 61435 invoked by uid 500); 17 Oct 2007 17:52:29 -0000 Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@openjpa.apache.org Delivered-To: mailing list dev@openjpa.apache.org Received: (qmail 61424 invoked by uid 99); 17 Oct 2007 17:52:29 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 17 Oct 2007 10:52:29 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 17 Oct 2007 17:52:41 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 9926D7141FE for ; Wed, 17 Oct 2007 10:51:50 -0700 (PDT) Message-ID: <26454308.1192643510624.JavaMail.jira@brutus> Date: Wed, 17 Oct 2007 10:51:50 -0700 (PDT) From: "Patrick Linskey (JIRA)" To: dev@openjpa.apache.org Subject: [jira] Created: (OPENJPA-407) Cache SQL (or closer precursors to SQL) more aggressively MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org 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: 1.0.0, 0.9.7, 0.9.6, 0.9.0 Reporter: Patrick Linskey Fix For: 1.1.0 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.