gettting value by column name vs index

[rudra tripathy]

Hi All,

Should we use rs.getString("columnname") or rs.getString(columnindex) and which one is fatser?

[Paul Sturrock]

Faster is neither here nor there.

Name is safer. If you change the order of fields in your select statement your index based logic is broken.

[rudra tripathy]

Thanks for the reply. Yeah.. Our architect is trying to push for column index and he claimed it is faster by column index. Tried googling, but couldn't get any definite answer for this.

Thannks
Rdura

[Bear Bibeault]

Ask for proof.