ResultSet: Retrieving column values by index versus retrieving by label

by

Warning: I’m going to get bombastic here, because this drives me crazy.

99%* of the time, it’s a ridiculous micro-optimization that people have some vague idea makes things ‘better’. This completely ignores the fact that, unless you’re in an extremely tight and busy loop over millions of SQL results all the time, which is hopefully rare, you’ll never notice it. For everyone who’s not doing that, the developer time cost of maintaing, updating, and fixing bugs in the column indexing are far greater than the incremental cost of hardware for your infinitesimally-worse-performing application.

Don’t code optimizations like this in. Code for the person maintaining it. Then observe, measure, analyse, and optimize. Observe again, measure again, analyse again, and optimize again.

Optimization is pretty much the last step in development, not the first.

* Figure is made up.

More Related Contents:

  1. How do I get the size of a java.sql.ResultSet?
  2. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  3. When to close Connection, Statement, PreparedStatement and ResultSet in JDBC
  4. JDBC driver throws “ResultSet Closed” exception on empty ResultSet
  5. JDBC ResultSet get columns with table alias
  6. Execute anonymous pl/sql block and get resultset in java
  7. ResultSet.getString(1) throws java.sql.SQLException: Invalid operation at current cursor position
  8. How to get row count using ResultSet in Java?
  9. How to get the number of columns from a JDBC ResultSet?
  10. How do I get the row count in JDBC?
  11. Convert a Result Set from SQL Array to Array of Strings
  12. Must JDBC Resultsets and Statements be closed separately although the Connection is closed afterwards?
  13. Reusing a PreparedStatement multiple times
  14. MySQL and JDBC with rewriteBatchedStatements=true
  15. Why does the JVM still not support tail-call optimization?
  16. How to connect SQLite with Java?
  17. “Loading class com.mysql.jdbc.Driver … is deprecated” message
  18. Getting Database connection in pure JPA setup
  19. Returning a ResultSet
  20. How to change MySQL timezone in a database connection using Java?
  21. How to configure Tomcat to connect with MySQL
  22. Print All JVM Flags
  23. What is the most recommended way to store time in PostgreSQL using Java?
  24. Native Library sqljdbc_auth.dll already loaded in another classloader
  25. how to get list of Databases “Schema” names of MySql using java JDBC
  26. NamedParameterJdbcTemplate vs JdbcTemplate
  27. Do java finals help the compiler create more efficient bytecode? [duplicate]
  28. MyBatis executing multiple sql statements in one go, is that possible?
  29. A persistent connection with JDBC to MySQL
  30. Why proguard processes AndroidManifest.xml

Leave a Comment