Return-Path: Delivered-To: apmail-openjpa-dev-archive@www.apache.org Received: (qmail 26203 invoked from network); 16 Oct 2008 16:20:35 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 16 Oct 2008 16:20:35 -0000 Received: (qmail 18484 invoked by uid 500); 16 Oct 2008 16:20:37 -0000 Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org Received: (qmail 18325 invoked by uid 500); 16 Oct 2008 16:20:36 -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 18314 invoked by uid 99); 16 Oct 2008 16:20:36 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 16 Oct 2008 09:20:36 -0700 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 16 Oct 2008 16:19:37 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 3EF35234C22F for ; Thu, 16 Oct 2008 09:19:44 -0700 (PDT) Message-ID: <10878314.1224173984250.JavaMail.jira@brutus> Date: Thu, 16 Oct 2008 09:19:44 -0700 (PDT) From: "Jeremy Bauer (JIRA)" To: dev@openjpa.apache.org Subject: [jira] Created: (OPENJPA-748) Disable QuerySQLCache by default MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Disable QuerySQLCache by default -------------------------------- Key: OPENJPA-748 URL: https://issues.apache.org/jira/browse/OPENJPA-748 Project: OpenJPA Issue Type: Bug Components: jdbc Affects Versions: 1.2.0, 1.3.0 Reporter: Jeremy Bauer Assignee: Jeremy Bauer I posted this dev forum question regarding QuerySQLCache: --- We've had a few regression-type issues (OPENJPA-660 & OPENJPA-731) since the addition of QuerySQLCache in 1.2.0. While this cache has shown to provide significant performance improvements for certain scenarios, I think we should consider disabling the cache by default. The main reason is the potential for future regression issues. Another reason is that we didn't follow the pattern set by existing caches. With the exception of the query compilation cache (which is relatively static after queries are initialized), the other caches are disabled by default. While the cache is supposed to be transparent, it could (and has shown to) affect the behavior of an application that has been working for quite some time on a prior release. Arguably, QuerySQLCache may just need more rigorous testing. While additional testing may help, testing every scenario is difficult and if we miss one, regression issues due to performance enhancements are pretty hard to swallow. I think a better approach is to allow users to enable the cache if they choose to do so. --- And received positive responses. The necessary updates will be made to disable the cache by default and committed to trunk. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.