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 <[EMAIL PROTECTED]> 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 > >
