From dev-return-20193-apmail-openjpa-dev-archive=openjpa.apache.org@openjpa.apache.org Wed Feb 22 19:28:13 2012 Return-Path: X-Original-To: apmail-openjpa-dev-archive@www.apache.org Delivered-To: apmail-openjpa-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 208A7986B for ; Wed, 22 Feb 2012 19:28:13 +0000 (UTC) Received: (qmail 20847 invoked by uid 500); 22 Feb 2012 19:28:12 -0000 Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org Received: (qmail 20814 invoked by uid 500); 22 Feb 2012 19:28:12 -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 20806 invoked by uid 99); 22 Feb 2012 19:28:12 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 22 Feb 2012 19:28:12 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED,T_RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.116] (HELO hel.zones.apache.org) (140.211.11.116) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 22 Feb 2012 19:28:10 +0000 Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116]) by hel.zones.apache.org (Postfix) with ESMTP id 455E833511E for ; Wed, 22 Feb 2012 19:27:49 +0000 (UTC) Date: Wed, 22 Feb 2012 19:27:49 +0000 (UTC) From: "Kevin Sutter (Commented) (JIRA)" To: dev@openjpa.apache.org Message-ID: <1347221220.5699.1329938869285.JavaMail.tomcat@hel.zones.apache.org> In-Reply-To: <2146034782.16015.1328729340747.JavaMail.tomcat@hel.zones.apache.org> Subject: [jira] [Commented] (OPENJPA-2123) Minor performance improvements for Connection and ResultSet processing MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/OPENJPA-2123?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13213898#comment-13213898 ] Kevin Sutter commented on OPENJPA-2123: --------------------------------------- There may be occasions where String columns in a database contain large amounts of unnecessary trailing whitespace. To alleviate the movement and processing of this whitespace, I am introducing a DBDictionary property to optionally trim this trailing whitespace after retrieving a String field from a ResultSet. The default value for this new property (DBDictionary.trimStringColumns) will be "false" to allow existing applications to continue executing as they have today. But, for those applications where the removal of this whitespace can provide a performance benefit, this property can be set to "true" and then trim() will be called on the String result before returning it to the Entity. > Minor performance improvements for Connection and ResultSet processing > ---------------------------------------------------------------------- > > Key: OPENJPA-2123 > URL: https://issues.apache.org/jira/browse/OPENJPA-2123 > Project: OpenJPA > Issue Type: Bug > Components: jdbc, performance > Affects Versions: 2.3.0, 2.2.1 > Reporter: Kevin Sutter > Assignee: Kevin Sutter > Fix For: 2.3.0, 2.2.1 > > > Came across a few items that could help with performance in certain scenarios. I'll document each one as I determine the proper resolution. The first one is that we were preparing the ability to print the SQL parameters even if no configuration properties were set requesting that capability. This resulted in String and StringBuffer operations that were extra overhead on every interaction with the Connection. > More to come... -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira