This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes HANDLING RESULTSET 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 "HANDLING RESULTSET" Watch "HANDLING RESULTSET" New topic
Author

HANDLING RESULTSET

Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
Hi all,
i am having a small issue which is as follows:
After an execute query the datas are in the resultset
and to access them we scroll through the resultset using the
next() method for every row but this is a time consuming affair
more so since we have to handle a large volume of data and is almost taking 1-2 mins to scroll through the entire result set..
So is there any way we can extract the entire data in a single go
so that the time lost in calling next() in a while (true) loop
is saved .
thanx in advance

anirvan
rani bedi
Ranch Hand

Joined: Feb 06, 2001
Posts: 358
well there is no way to traverse across the resultset without the next statement.
A better way to improve the performance is to optimise your query so that number of records in the results are reduced.


Cheers,<br />Rani<br />SCJP, SCWCD, SCBCD
 
 
subject: HANDLING RESULTSET
 
Similar Threads
Check the result set
JDBC ResultSet
Resultset returned by stored proc not forward only
pagination strategy using caching & ajax
error - exhausted result set