Solved

How does resultset behave ?

Posted on 2006-10-31
3
499 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
  • 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
In this post we will learn different types of Android Layout and some basics of an Android App.
Video by: Michael
Viewers learn about how to reduce the potential repetitiveness of coding in main by developing methods to perform specific tasks for their program. Additionally, objects are introduced for the purpose of learning how to call methods in Java. Define …
Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…

685 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