I have done some JDBC previously where I fired some SQL queries at a database
from a Java application and get the results in a ResultSet. Can anybody tell me
whether the ResultSet contain the actual result or does it merely references
the actual data in the database?
The reason why I am asking this is because I need to process a very hugh table
in a database one tuple at a time. My fear is that my machine may not be able
to handle such a large amount of data if the ResultSet actually returns all the
data from my query. However, if the ResultSet merely references the data and
does not take up much space itself, then I will have no problems.
What I want to do is to read each tuples in a database and process them. Using
SQL queries to retrieve one row at a time is clearly not an option because of
the time required for each query to execute and return the result. Can anybody
tell me whether there is any other way of processing one tuple from a table
at a time?
Thank you very much for any help,