What is the right time to close ResultSet

Vote count:

0

I have a Java ResultSet which contains a huge data amount, retrieved from the database. I'm going to work with this data. From the performance point of view, should I copy ResultSet content to some data structure in order to be able to close the result set as soon as possible and to work with the data from a new container or it's better to do not waste a time on copy the content and work with the data directly from the ResultSet ?

Is it "heavy" to maintain/store in RAM the ResultSet object?

asked 25 secs ago

Mike

1,587

What is the right time to close ResultSet