Return-Path: Delivered-To: apmail-incubator-ibatis-user-java-archive@www.apache.org Received: (qmail 78811 invoked from network); 15 Apr 2005 19:33:32 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 15 Apr 2005 19:33:32 -0000 Received: (qmail 84956 invoked by uid 500); 15 Apr 2005 19:33:29 -0000 Delivered-To: apmail-incubator-ibatis-user-java-archive@incubator.apache.org Received: (qmail 84913 invoked by uid 500); 15 Apr 2005 19:33:28 -0000 Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm Precedence: bulk Reply-To: ibatis-user-java@incubator.apache.org List-Help: List-Unsubscribe: List-Post: List-Id: Delivered-To: mailing list ibatis-user-java@incubator.apache.org Received: (qmail 84881 invoked by uid 99); 15 Apr 2005 19:33:28 -0000 X-ASF-Spam-Status: No, hits=0.5 required=10.0 tests=DNS_FROM_RFC_ABUSE,HTML_40_50,HTML_MESSAGE,RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: domain of larry.meadors@gmail.com designates 64.233.162.206 as permitted sender) Received: from zproxy.gmail.com (HELO zproxy.gmail.com) (64.233.162.206) by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 15 Apr 2005 12:33:26 -0700 Received: by zproxy.gmail.com with SMTP id 18so1674700nzp for ; Fri, 15 Apr 2005 12:33:23 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:references; b=D20CkdNUq7NFabIA5bKqIibdk+e0e9VAa8f8eARCVX68db4q6ulzrWuVXl48CbbO2i2N27u8tZTDW6xWuWcF9leXpeJPUKOTN3uOunig7yb9BRIxrwGiAO3wFaGe47RQzUod6z8NAgTq/zRrr5kVA2uTnFy4Y8/wdpXMt4AyMzU= Received: by 10.36.86.19 with SMTP id j19mr219897nzb; Fri, 15 Apr 2005 12:33:23 -0700 (PDT) Received: by 10.36.90.19 with HTTP; Fri, 15 Apr 2005 12:33:23 -0700 (PDT) Message-ID: Date: Fri, 15 Apr 2005 13:33:23 -0600 From: Larry Meadors Reply-To: lmeadors@apache.org To: ibatis-user-java@incubator.apache.org Subject: Re: iBatis configurations for performance In-Reply-To: <46225033AA90B54D842D85582F094F080411A6@sdbahexc03.agriculture.gov.ie> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_8567_23768081.1113593603663" References: <46225033AA90B54D842D85582F094F080411A6@sdbahexc03.agriculture.gov.ie> X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N ------=_Part_8567_23768081.1113593603663 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline If you hit the database up to 50 times in one transaction, nothing you can= =20 do to iBATIS will help as much as eliminating that. Is it possible to replace some of that with stored procedures, or other=20 techniques? Larry On 4/15/05, Ross, Hugh wrote: >=20 > Hi, > I am running a performance test on an application using iBatis. I am=20 > testing with 300 users. > Some of our business object methods may hit database up to 50 times in on= e=20 > transaction. Performance is currently very poor. Any ideas what I should= =20 > have my SQLMap settings to for optimum performance? >=20 > My current settings are: > cacheModelsEnabled=3D"true" > enhancementEnabled=3D"true" > maxSessions=3D"250" > maxTransactions=3D"25" > maxRequests=3D"512" > useStatementNamespaces=3D"true"/> >=20 > Many thanks, > Hugh >=20 > ********************************************************************** > *********** Department of Agriculture and Food *************** >=20 > The information contained in this email and in any > attachments is confidential and is designated solely > for the attention and use of the intended recipient(s). > This information may be subject to legal and professional > privilege. If you are not an intended recipient of > this email, you must not use, disclose, copy, > distribute or retain this message or any part of it. > If you have received this email in error, please > notify the sender immediately and delete all copies of > this email from your computer system(s). > ********************************************************************** >=20 > ------=_Part_8567_23768081.1113593603663 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline If you hit the database up to 50 times in one transaction, nothing you can = do to iBATIS will help as much as eliminating that.

Is it possible to replace some of that with stored procedures, or other tec= hniques?

Larry

On 4/15/05, Ross, Hugh <Hugh.Ross@agriculture.gov.ie> wrote:

Hi,
I am running a performance test on an application using iBatis. I am= testing with 300 users.
Some of our business object methods may hit database up to 50 times in one transaction. Performance is currently very poor. Any ideas what I should have my SQLMap settings to for optimum performance?

My curren= t settings are:
         <set= tings
           =      cacheModelsEnabled=3D"true"
&nbs= p;            &= nbsp;  enhancementEnabled=3D"true"
            = ;    maxSessions=3D"250"
   = ;            &n= bsp;maxTransactions=3D"25"
      = ;          maxRequests=3D= "512"
         &n= bsp;      useStatementNamespaces=3D"true= "/>

Many thanks,
Hugh

***********************************************************= ***********
***********  Department of Agriculture and Food **= *************

The information contained in this email and in any
= attachments is confidential and is designated solely
for the attention and use of the intended recipient(s).
This informa= tion may be subject to legal and professional
privilege.  If y= ou are not an intended recipient of
this email, you must not use, disclo= se, copy,
distribute or retain this message or any part of it.
If you have rec= eived this email in error, please
notify the sender immediately and dele= te all copies of
this email from your computer system(s).
***********= ***********************************************************

------=_Part_8567_23768081.1113593603663--