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:[EMAIL PROTECTED] 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/springframew ork/orm/ibatis/SqlMapClientTemplate.html org.springframework.orm.ibatis Class SqlMapClientTemplate public List <http://java.sun.com/j2se/1.4.2/docs/api/java/util/List.html> queryForList(String <http://java.sun.com/j2se/1.4.2/docs/api/java/lang/String.html> statementName, Object <http://java.sun.com/j2se/1.4.2/docs/api/java/lang/Object.html> 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, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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
