ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sanjay_Deshpa...@amway.com
Subject Fw: ibatis with Spring performance issue.
Date Fri, 17 Nov 2006 14:52:18 GMT

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