row read performance

Say I have an array of unordered non contiguous primary keys
what is likely to be the most efficient way to retrieve their associated
rows?

select between min and max id which I'd have to ascertain first
individual selects for each id
select * and compile a list by testing ids?

this is made more pertinent since one of my db columns is a 2-3KB Blob
object

I think that iterating a ResultSet only actually retrieves rows from the
database as you call myResultSet.next() or perhaps in small batches?

But does the tuple read operate in the same way?

ie if I never do rs.getObject()for my large object then does that speed that
row access up?

TIA
--
Mike W



.

Relevant Pages