Java Resultset.get *** (...) faster with string or int?

Question

When you restart using the result set

while (rs.next()){
...
}

To get column data (e.g. long), it’s faster to use

rs.getLong(String columnLabel)

or

rs.getLong(int columnIndex)

Presumably, columnLabel is better used in many ways for stronger code, but are there any significant losses during operation, each time comparing columns with a row (we are talking about table sizes ~ 40 m rows)?

Answer 1

I would bet that compared to the cost of preparing a set of results, the difference is careless. Favorable code.

Answer 2

! .

- , .

1. , , . : . iLast_Name.

2. , . "Last_Name" 3, "iLast_Name" 3.

3. GET/SET. / , , .

. ( ) , .

Answer 3

, , , .

: , , select * from ...., ResultSet, String a = resultSet.getString(1), int i = resultSet.getInt(2) .. ..

, ... , int. , .

, . , , , .

Answer 4

. - , . -, . , , . , , , .