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
