Return-Path: 
 <user-java-return-6402-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 58176 invoked from network); 17 Mar 2006 17:32:29 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 17 Mar 2006 17:32:29 -0000
Received: (qmail 25335 invoked by uid 500); 17 Mar 2006 17:32:26 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 25279 invoked by uid 500); 17 Mar 2006 17:32:26 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 25248 invoked by uid 99); 17 Mar 2006 17:32:26 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 17 Mar 2006 09:32:25 -0800
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [195.130.132.58] (HELO astra.telenet-ops.be) (195.130.132.58)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 17 Mar 2006 09:32:24 -0800
Received: from localhost (localhost.localdomain [127.0.0.1])
	by astra.telenet-ops.be (Postfix) with SMTP id F1696D0079
	for <user-java@ibatis.apache.org>; Fri, 17 Mar 2006 18:32:03 +0100 (CET)
Received: from [213.118.81.209] (dD57651D1.access.telenet.be [213.118.81.209])
	by astra.telenet-ops.be (Postfix) with ESMTP id C0298D0066
	for <user-java@ibatis.apache.org>; Fri, 17 Mar 2006 18:32:03 +0100 (CET)
Message-ID: <441AF262.3010001@pandora.be>
Date: Fri, 17 Mar 2006 18:31:14 +0100
From: Sven Boden <list123@pandora.be>
Reply-To: list123@pandora.be
User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: user-java@ibatis.apache.org
Subject: Re: Very slow query
References: <1142615625.13224.34.camel@isol16.vilspa.esa.int>
 <a10a823c0603170914m3000c872w14794f7a9819ffa@mail.gmail.com>
In-Reply-To: <a10a823c0603170914m3000c872w14794f7a9819ffa@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N


The pool query is not used as Pool.PingEnabled is false. ;-)

Try rerunning it setting cacheModelsEnabled to false (for a performance 
run, in a real system if you have a cache hit the cache speeds up 
processing, for a single run a cache slows down), and switch off 
debugging if you have it on.

Regards,
Sven

Larry Meadors wrote:

><property name="Pool.PingQuery" value="select * from data_set"/>
>
>What is "data_set", and how long does "select * from data_set" take to run?
>
>Larry
>
>
>On 3/17/06, Nicolas Fajersztejn <Nicolas.Fajersztejn@sciops.esa.int> wrote:
>  
>
>> Hi,
>>
>> I'm new to iBatis. I have been using it for a couple of months and really
>>like it.
>>
>> However, now I am having problems with a very simple query. This is the
>>mapping I have:
>>
>> <select id="getExposuresForObsId"
>>resultClass="xat.proprietarydates.objects.Exposure">
>>    SELECT
>>     obsid obsID,
>>     inst inst,
>>     epic_filter epicFilter
>> FROM xsa..exposures
>> WHERE
>>             obsid = #value#
>> </select>
>>
>>
>> obsid is a numeric value. I am passing an Integer as parameter and this
>>query takes about 1400 ms to execute!!!
>> The same query run with explicit value (obsid = 100 for example) takes only
>>48 ms.
>>
>> Does it really take so much time to convert an Integer and build up the
>>query or am I missing something?
>>
>> This is my config file in case it helps:
>>
>>     <transactionManager type="JDBC">
>>       <dataSource type="SIMPLE">
>>       <property name="JDBC.Driver" value="${driver}"/>
>>       <property name="JDBC.ConnectionURL" value="${url}"/>
>>       <property name="JDBC.Username" value="${username}"/>
>>       <property name="JDBC.Password" value="${password}"/>
>>       <property name="JDBC.DefaultAutocommit" value="true"/>
>>       <!-- The following are optional -->
>>       <property name="Pool.MaximumActiveconnections" value="10"/>
>>       <property name="Pool.MaximumIdleConnections" value="5"/>
>>       <property name="Pool.MaximumCheckoutTime" value="120000"/>
>>       <property name="Pool.TimeToWait" value="10000"/>
>>       <property name="Pool.PingQuery" value="select * from data_set"/>
>>       <property name="Pool.PingEnabled" value="false"/>
>>       <property name="Pool.PingConnectionOlderThan" value="0"/>
>>       <property name="Pool.PingConnectionNotUsedFor" value="0"/>
>>       </dataSource>
>>     </transactionManager>
>>
>> <settings
>> cacheModelsEnabled="true"
>> enhancementEnabled="true"
>> lazyLoadingEnabled="true"
>> maxRequests="32"
>> maxSessions="10"
>> maxTransactions="5"
>> useStatementNamespaces="false"
>> />
>>
>>
>> And the Java code:
>>
>>     public static List getExposuresForObsId(Integer obsID) {
>>         SqlMapClient sqlMap = XATSqlConfig.getSqlMapInstance();
>>         List exposureList = null;
>>         try {
>>             long t1 = System.currentTimeMillis();
>>             exposureList = sqlMap.queryForList("getExposuresForObsId",
>>obsID);
>>             long t2 = System.currentTimeMillis();
>>             System.out.println("time queryForList is " + (t2-t1));
>>
>>         }
>>         catch (SQLException e) {
>>             logger.log(Level.WARNING, "SQLException getting exposures list:
>>" + e);
>>         }
>>         return exposureList;
>>     }
>>
>>
>>
>> I would gladly appreciate your help.
>>
>> Thanks.
>>
>>
>>
>>
>>
>>    
>>
>
>
>  
>