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
posted 10 years ago
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.