Alex Schearer
17 years ago
-- Sorry not sure if the first one made it through the mail list
admin --
When I retrieve a record set from a select statement does that pull
all of the records from the database immediately, or does it pull a
record one-at-a-time when ResultSetIterator.next() is called?
Specifically, I'm trying to understand what the memory requirements
are when requesting a large number of records. I am trying to
determine what cost pulling all of the records into an array will
carry. If the RecordSet is lazily loading the records then the cost
is higher.
Thanks, Alex
admin --
When I retrieve a record set from a select statement does that pull
all of the records from the database immediately, or does it pull a
record one-at-a-time when ResultSetIterator.next() is called?
Specifically, I'm trying to understand what the memory requirements
are when requesting a large number of records. I am trying to
determine what cost pulling all of the records into an array will
carry. If the RecordSet is lazily loading the records then the cost
is higher.
Thanks, Alex