Hi All,
Finally I was able to achieve a better performance in retrieving 6 lacs rows and writing to a flat file. It takes nearly 6 minutes now. I was using a Row Handler implementation initially, but still I was not able to get a better performance, today I added fetchSize="5000" to the select clause and then it really turn around the solution. Now I have few questions on this, 1. How do we tune the fetchSize value? 2. Why by adding this fetchSize the retrieval became so fast than the initial version, as the initial version was taking 3 hours to write 6 lacs of records to a file? Is there any signifance? Please enlighten. Thanks Naresh ________________________________ From: Kyunam Kim [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2008 1:10 AM To: [email protected] Subject: RE: Regarding Bulk Data Select Query Performance. Or if you need to write out to a file in a customized way, RowHandler seems to be a perfect candidate. Thanks, Q ________________________________ From: Chris O'Connell [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2008 12:17 PM To: [email protected] Subject: RE: Regarding Bulk Data Select Query Performance. Do you need to use IBATIS? What is your database? Many (most?) databases have tools which are well suited to these sorts of tasks. Depending on your database, I would look at using one of them instead of IBATIS. From: Rajaram, Naresh [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2008 1:56 PM To: [email protected] Subject: Regarding Bulk Data Select Query Performance. Hi All, I am a newbie in using IBATIS Framework. In one of our project (This is a Java Project, which is basically an Extract Tool) we are using IBATIS. There is a select query which is going to fetch approx 6,00,000 records. These values have to be written to a text file. Now what is the best approach to handle this? How to achieve better performance using IBATIS? Please suggest. Thanks Naresh This email and any files transmitted with it are confidential, proprietary and intended solely for the individual or entity to whom they are addressed. If you have received this email in error please delete it immediately. No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.169 / Virus Database: 270.6.19/1664 - Release Date: 9/10/2008 6:00 AM This email and any files transmitted with it are confidential, proprietary and intended solely for the individual or entity to whom they are addressed. If you have received this email in error please delete it immediately.
