jQuery in Action, 2nd edition*
The moose likes JDBC and the fly likes Reg: Fetch Size Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Reg: Fetch Size" Watch "Reg: Fetch Size" New topic
Author

Reg: Fetch Size

nilima komala
Greenhorn

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,
komala
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 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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Reg: Fetch Size
 
Similar Threads
Hibernate fetch size
how to fetch JSP text field value
rs.next() bottle neck
About ResultSet
db2 type 4 driver result set fetch size