Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2005
    Posts
    16

    Unanswered: setFetchSize() method

    Hi frnds,

    For jdbc driver ....

    how to improve dabase record fetch time using setFetchSize() method ??

    Shld i use setfetchsize method with Statement object or with ResultSet object ???

    What is the defference between the 2 methods ?

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    I thnk u shld set ftchsz to da nmbr of rcrds u r going to wrk wth at a time. For xmpl if u show rslts to ur usr 20 rws at a time u shud set ftchsz to twnty; zis won't dcrs da total ftch time bt wil brng da frst 20 rcrds fastr.

    u shld setfetchsize wth Statement bcs with ResultSet its alrdy 2 late.

    i hp ths is clr.

  3. #3
    Join Date
    Dec 2005
    Posts
    16
    Hi
    Thnx for reply ..

    I m not designing UI or Web based application.
    It is XML based request - response application ...

    The resultset can contain records of extremely varying size ranging from 2 to 4000 ...

    The reply XML contains these records.

    So what fetchsize i shld use ?

    Currently i have stmt fetch size = 1000 and resultset.fetchsize = 20 ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •