ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kiran vuppla <kirankumar_vup...@yahoo.com>
Subject RE: Need information regarding Row Handler implementation usage.
Date Fri, 07 Nov 2008 19:00:26 GMT
Might be you need to get the source code of iBatis and try debugging seeing the log statements.
Do enable the logging for the iBatis and see how much time it takes to execute the RowHandler()
if it is not from your application.

If it is from your application you can put some debug statements.

-Kiran

--- On Fri, 11/7/08, ankit.khujneri@wipro.com <ankit.khujneri@wipro.com> wrote:
From: ankit.khujneri@wipro.com <ankit.khujneri@wipro.com>
Subject: RE: Need information regarding  Row Handler implementation usage.
To: user-java@ibatis.apache.org
Date: Friday, November 7, 2008, 10:45 AM



 
Thanks Kiran for your inputs. Do have any idea how we
can compute the response time the handler takes to prepare the result
set?
Actaully, I need to analyze if using a rowHandler for
large result set can be pain.
 
Regards
Ankit



From: kiran vuppla
[mailto:kirankumar_vuppla@yahoo.com] 
Sent: Friday, November 07, 2008
10:04 PM
To: user-java@ibatis.apache.org
Subject: Re: Need
information regarding Row Handler implementation usage.




  
  
    
      http://static.springframework.org/spring/docs/1.1.5/api/org/springframework/orm/ibatis/SqlMapClientTemplate.html

      org.springframework.orm.ibatis 
Class
      SqlMapClientTemplate

public List queryForList(String statementName,
                         Object parameterObject,
                         int skipResults,
                         int maxResults)

I am not sure. Take a look at this. This might help. For this method
you can give the range of rows/result/objects you want.

-Kiran


---
      On Fri, 11/7/08, ankit.khujneri@wipro.com
      <ankit.khujneri@wipro.com> wrote:

      From:
        ankit.khujneri@wipro.com <ankit.khujneri@wipro.com>
Subject:
        Need information regarding Row Handler implementation usage.
To:
        user-java@ibatis.apache.org
Date: Friday, November 7, 2008, 8:59
        AM


        
        Hi,
         
        I am
        executing one SQL that implements the usage of rowHandler. This SQL
        fetches more than 200K records which is affecting the overall
        application performance.
         
        I want to identify the time taken by the
        row Handler to execute the SQL and fetch
record.
         
        Is there
        any way to differentiate the query response time and time taken by the
        logic implemented in handleRow() method.
         
        Is there
        any document/Forum/blog that can describe the handleRow()
        method?
         
        Thanks
        
         
        Ankit
         
         
        Please
        do not print this email unless it is absolutely necessary.
        
        The information contained in this electronic message and any
        attachments to this message are intended for the exclusive use of the
        addressee(s) and may contain proprietary, confidential or privileged
        information. If you are not the intended recipient, you should not
        disseminate, distribute or copy this e-mail. Please notify the sender
        immediately and destroy all copies of this message and any attachments.
        
        WARNING: Computer viruses can be transmitted via email. The recipient
        should check this email and any attachments for the presence of viruses.
        The company accepts no liability for any damage caused by any virus
        transmitted by this email. 
        www.wipro.com

 Please do not print this email unless it is absolutely necessary.  


 The information contained in this electronic message and any attachments to this message
are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential
or privileged information. If you are not the intended recipient, you should not disseminate,
distribute or copy this e-mail. Please notify the sender immediately and destroy all copies
of this message and any attachments. 

WARNING: Computer viruses can be transmitted via email. The recipient should check this email
and any attachments for the presence of viruses. The company accepts no liability for any
damage caused by any virus transmitted by this email. 

www.wipro.com




      
Mime
View raw message