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" <[EMAIL PROTECTED] org> To Sent by: [email protected] [EMAIL PROTECTED] cc il.com Subject Re: ibatis with Spring performance 11/09/2006 04:45 isssue. PM Please respond to [EMAIL PROTECTED] 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, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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 > >
