JDBC ResultSet.absolute() vs. Limit

Question

What's the preferred method to fetch a subset of records from the database? Use rs.absolute() or Limit?

Answer 1

It's almost certainly going to be more efficient to craft your SQL to only return the results you want. It also better expresses your intent.