Solved

How does resultset behave ?

Posted on 2006-10-31
3
509 Views
Last Modified: 2008-02-01
I have a method which iterates over result set.

If the resultset fetchsize is increased to 2000, the method takes less time, so I wondered :

If the result set is 80 and I had a fetch size of only 8 , then would the app hit the database after every 8 records it fetched ?

Thank you.
0
Comment
Question by:letsbedecent
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 92

Accepted Solution

by:
objects earned 125 total points
ID: 17848141
yes, each time new rows are needed by the result set another 8 rows would be fetched.
0
 

Author Comment

by:letsbedecent
ID: 17848151
So, that would add the time taken to iterate through the result set, especially if the network latency between app server and db server is not negligible ?
0
 
LVL 92

Expert Comment

by:objects
ID: 17848168
correct
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Are you developing a Java application and want to create Excel Spreadsheets? You have come to the right place, this article will describe how you can create Excel Spreadsheets from a Java Application. For the purposes of this article, I will be u…
Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
The viewer will learn how to implement Singleton Design Pattern in Java.

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question