ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brandon Goodin" <brandon.goo...@gmail.com>
Subject Re: Fw: ibatis with Spring performance issue.
Date Fri, 17 Nov 2006 16:36:20 GMT
The monthly ambiguous performance question. If you are going to make
question/statements on performance, please provide better information about
how your reached the conclusion that prompted the question. Otherwise your
question is akin to asking how big the universe is.

Thanks :)
Brandon

On 11/17/06, Sanjay_Deshpande@amway.com <Sanjay_Deshpande@amway.com> wrote:
>
>
> Any ideas why the CPU usage is more when using Ibatis vs regular JDBC.
>
> Thanks.
>
> Regards,
> Sanjay
> x7273
> ----- Forwarded by Sanjay Deshpande/IT/Quixtar on 11/17/2006 09:50 AM
> -----
>
>              Sanjay
>              Deshpande/IT/Quix
>              tar                                                        To
>                                        user-java@ibatis.apache.org
>              11/10/2006 02:19                                           cc
>              PM                        larry.meadors@gmail.com,
>                                        user-java@ibatis.apache.org, Attila
>                                        Halasz/IT/Quixtar@Alticor, Nate
>                                        Pett/IT/Quixtar@Alticor
>                                                                    Subject
>                                        Re: ibatis with Spring performance
>                                        issue.(Document link: Sanjay
>                                        Deshpande)
>
>
>
>
>
>
>
>
>
> Thanks  Larry for your quick Response. Here is our SQLMAP-config file
> details.
>
> <?xml version="1.0" encoding="UTF-8"?>
> <!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config
> 2.0
> //EN" "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
> <sqlMapConfig>
>       <!-- These settings control SqlMapClient configuration details,
> primarily to do with transaction
>             management. They are all optional (more detail later in this
> document). -->
>       <settings  cacheModelsEnabled="true" enhancementEnabled="true"
>             lazyLoadingEnabled="true" maxRequests="512" maxSessions="256"
>             maxTransactions="32" useStatementNamespaces="true"
> classInfoCacheEnabled="true"
>             errorTracingEnabled="false"/>
>
>
>       <sqlMap
>             resource="SqlMap.xml" />
>
> </sqlMapConfig>
>
> The query in SqlMap.xml is as follows
>
> <resultMap id="detailMap" class="com.mycompany.dto.Detail">
>       <result property="typeCode" column="typeCode" columnIndex="1" />
>       <result property="xAmount" column="xTotal" columnIndex="2" jdbcType=
> "DECIMAL" />
>       <result property="yAmount" column="yTotal" columnIndex="3" jdbcType=
> "DECIMAL"/>
>       <result property="numberOfCustomers" column="numberOfCustomers"
> columnIndex="4" jdbcType="DECIMAL"/>
>       <result property="numberOfOrders" column="numberOfOrders"
> columnIndex
> ="5" jdbcType="DECIMAL" />
>       <result property="currency" column="currency" columnIndex="6" />
> </resultMap>
>
>
> <select id="getDetailInformation" resultMap="detailMap"  remapResults=
> "false"
>              parameterClass="java.util.Map"  >
>              SELECT JLAWPK as typeCode,SUM(JLAWPL) as xTotal, SUM(JLAWPM)
> as yTotal, SUM(JLAWPN) as           numberOfCustomers, SUM(JLAWPO) as
> numberOfOrders, JLK2CD as currency
>              FROM Table1
>              WHERE JLAEPA = #idNumber:DECIMAL# AND JLAF4H =
> #period:DECIMAL# AND JLAWPK = #transactionCode:VARCHAR#
>              GROUP BY JLAEPA, JLAF4H, JLAWPK, JLK2CD
> </select>
>
>
>
> The data Base is AS400. We are running this on Websphere 6.1.
>
> When we run the JProfiler for both the JDBC and spring-iBatis
> implementation on this test Application , we notice that the  CPU
> utilisation is very high in case of the spring-ibatis implementation.
>
> Please advise us on how we can configure ibatis to resolve this issue.  If
> needed we will provide the detailed Profiler trace.
>
>
>
>
>
>
>              "Larry Meadors"
>              <lmeadors@apache.
>              org>                                                       To
>              Sent by:                  user-java@ibatis.apache.org
>              larry.meadors@gma                                          cc
>              il.com
>                                                                    Subject
>                                        Re: ibatis with Spring performance
>              11/09/2006 04:45          isssue.
>              PM
>
>
>              Please respond to
>              user-java@ibatis.
>                 apache.org
>
>
>
>
>
>
> Heh, well...there are about 4,890,456,354 ways to configure that. :-)
>
> So, I guess if it's within your performance criteria don't worry about
> it. If it's not, look at it with a profiler and see what you can do to
> make it better. If it is a deficiency in the framework, we'll see what
> we can do to improve it.
>
> Larry
>
>
> On 11/9/06, Sanjay_Deshpande@amway.com <Sanjay_Deshpande@amway.com> wrote:
> >
> > We ran performance tests on one of our application with Spring/IBATIS vs
> > regular JDBC. As far as the response time goes it was roughly the same.
> But
> > the CPU usage was 4 to 5 times higher in Spring/IBATIS implementation.
> Has
> > anybody encountered the same issue.? Is that is normal Why?
> >
> > Thanks.
> >
> > Regards,
> > Sanjay
> > x7273
> >
> >
>
>
>

Mime
View raw message