• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Reg: Fetch Size

 
nilima komala
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Friends,


What is the advantage of Fetch Size and how can it be used in programming,and how it works
Thank you in advance

Best Regards,
komala
 
stu derby
Ranch Hand
Posts: 333
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The "fetch size" refers to buffering by the driver of the rows retrieved from the database; instead of retrieving one row at a time, each time ResultSet.next() is called, the driver may choose to transfer and buffer more rows at a time. Some drivers by default will retrieve all rows in the ResultSet; this can cause unnecesarry OutOfMemory errors. Other drivers have a low default value for the fetch size; this causes slowness due to excessive netwrok transfers of the data, and setting a higher fetch size improves performance.

Fetch size is usually set with Statement.setFetchSize(); some drivers (such as Oracle) have alternate ways of setting the fetch size that can be more convenient.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic