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
posted 14 years ago
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.