Setting fetchSize

2008-03-10 Thread wiwohka
Trying to set fetchSize on calls to stored procedure in the SQL mapping file - {call pkg.get_data(?,?,?,?,?, ?,?,?,?,?, ?,?)} But does not seem to affect. Smaller result set like 10 rows has better performance than larger result set like say 95 rows. This is

Re: Setting FetchSize in iBatis

2007-08-08 Thread Joe ONeil
start+50; Clinton Begin wrote: > > On the 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 kno

Re: Setting FetchSize in iBatis

2007-08-03 Thread Clinton Begin
On the 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 so

Setting FetchSize in iBatis

2007-08-03 Thread Gaurav Agarwal
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

pgsql & fetchsize

2007-03-08 Thread Chris Lamey
Hey all, I'm working on a quick and dirty app that unfortunately has to run on a machine with all of a gig of RAM with a decent size dataset (2M rows). I really want the 'fetchSize' attribute of the select element to work so my RowHandler runs lean and mean. The app basically is

Re: fetchSize

2007-02-13 Thread Tushar Kherde
gt; > > Page 57 - 61 of the developer guide. > > > > Cheers, > > Clinton > > > > On 2/13/07, Tushar Kherde <[EMAIL PROTECTED] > wrote: > > > I have mentioned the fetchSize in select element > > > > > > Following is the code

Re: fetchSize

2007-02-13 Thread Clinton Begin
> > sqlMapClient.queryForList ("findAllWhatevers", paramObj, skipThisMany, > getThisMany); > > Page 57 - 61 of the developer guide. > > Cheers, > Clinton > > On 2/13/07, Tushar Kherde <[EMAIL PROTECTED] > wrote: > &g

Re: fetchSize

2007-02-13 Thread Brandon Goodin
2/13/07, Tushar Kherde <[EMAIL PROTECTED]> wrote: > I have mentioned the fetchSize in select element > > Following is the code > > > id="ICE_COUNTRY.abatorgenerated_selectForIndex" > resultMap="abatorgenerated_IceCountryResult" > parameterClass=&quo

Re: fetchSize

2007-02-13 Thread Clinton Begin
Page 57 - 61 of the developer guide. Cheers, Clinton On 2/13/07, Tushar Kherde <[EMAIL PROTECTED]> wrote: I have mentioned the fetchSize in select element Following is the code select COUNTRY_CODE, COUNTRY_NAME, COUNTRY_SHORT_NAME, RECORD_STATUS, RECORD_ADDBY, REC

Re: fetchSize

2007-02-13 Thread Tushar Kherde
I have mentioned the fetchSize in select element Following is the code select COUNTRY_CODE, COUNTRY_NAME, COUNTRY_SHORT_NAME, RECORD_STATUS, RECORD_ADDBY, RECORD_ADDDATE, RECORD_EDITBY, RECORD_EDITDATE, RECORD_APPROVEBY, RECORD_APPROVEDATE, RECORD_DELETEBY

Re: fetchSize

2007-02-13 Thread Clinton Begin
ted using this statement. > If the value specified is zero, then the hint is ignored. The default > value is zero. > --- > > Clinton > > On 2/13/07, Tushar Kherde < [EMAIL PROTECTED]> wrote: > > I tried it with oracle 8i and driver jdbc14.jar but n

Re: fetchSize

2007-02-13 Thread Tushar Kherde
8i and driver jdbc14.jar but not working :( > I just added the fetchSize="5" attribute in select element. Is there > anything else i need to do please correct if i am wrong. > I am using iBATIS2.0 ( Note: i was using iBATIS1.0 and upgraded just by > changing jars ) > If poss

Re: fetchSize

2007-02-13 Thread Clinton Begin
nt is ignored. The default value is zero. --- Clinton On 2/13/07, Tushar Kherde <[EMAIL PROTECTED]> wrote: I tried it with oracle 8i and driver jdbc14.jar but not working :( I just added the fetchSize="5" attribute in select element. Is there anything else i need to do p

Re: fetchSize

2007-02-13 Thread Tushar Kherde
I tried it with oracle 8i and driver jdbc14.jar but not working :( I just added the fetchSize="5" attribute in select element. Is there anything else i need to do please correct if i am wrong. I am using iBATIS2.0 ( Note: i was using iBATIS1.0 and upgraded just by changing jars ) If

Re: fetchSize

2007-02-13 Thread Brandon Goodin
m foo where > rownum<10" in Oracle. > > Brandon > > > On 2/13/07, Tushar Kherde <[EMAIL PROTECTED]> wrote: > > Hi All, > > > > I want to use fetchsize in my select query. > > Can I get sample for this. > > > > -- > > With regards > > Tushar Kherde > >

Re: fetchSize

2007-02-13 Thread Clinton Begin
ck from the database then I suggest using queryForList(id, parmObject, skip, max) or placing it in your SQL statement like "select * from foo where rownum<10" in Oracle. Brandon On 2/13/07, Tushar Kherde <[EMAIL PROTECTED]> wrote: > Hi All, > > I want to use fetchsize

Re: fetchSize

2007-02-13 Thread Brandon Goodin
um<10" in Oracle. Brandon On 2/13/07, Tushar Kherde <[EMAIL PROTECTED]> wrote: Hi All, I want to use fetchsize in my select query. Can I get sample for this. -- With regards Tushar Kherde

fetchSize

2007-02-13 Thread Tushar Kherde
Hi All, I want to use fetchsize in my select query. Can I get sample for this. -- With regards Tushar Kherde

fetchSize

2006-10-16 Thread Brad Balmer
Is the fetchSize attribute used only for stored procedures? Is there a way to limit the number of rows brought back? -- ___ Brad Balmer Application Architect Peapod, Inc. 847-583-6306 This email may contain confidential or legally privileged information that is