ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Clinton Begin" <clinton.be...@gmail.com>
Subject Re: Setting FetchSize in iBatis
Date Fri, 03 Aug 2007 13:59:34 GMT
On the <select> tag you can set fetch size.  See the DTD.

http://ibatis.apache.org/dtd/sql-map-2.dtd

Clinton

On 8/3/07, Gaurav Agarwal <G.Agarwal@sun.com> wrote:
>
> Hi,
>
> I just wanted to know, if we can set the fetchsize for queries in
> iBatis. I wanted to do so, as the for some of the reports the query
> retrieves 10,000+ records and I wanted to reduce the no. of trips
> between appserver and db.
>
> Any other suggestions are welcome!
>
> --
> Regards
> Gaurav Agarwal
> Sun Microsystems Account, GTS
> CSC India Pvt. Ltd.
> Tel: +91 120 2582323 x3590 (India)
>      +1 302 781 1010 x3590 (US)
> (M): +91 98106-17911
>
>

Mime
View raw message