Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

HANDLING RESULTSET

 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 358
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic