It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes Reg: Fetch Size Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Reg: Fetch Size" Watch "Reg: Fetch Size" New topic

Reg: Fetch Size

nilima komala

Joined: Mar 03, 2005
Posts: 8
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,
stu derby
Ranch Hand

Joined: Dec 15, 2005
Posts: 333
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 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.
I agree. Here's the link:
subject: Reg: Fetch Size
jQuery in Action, 3rd edition