Solved

How does resultset behave ?

Posted on 2006-10-31
3
467 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 Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

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…
Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.

705 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now