You can improve performance on retrieving a result set from the database if you set the REPEAT_READ connection property to false. However, when REPEAT_READ is false:
You must read column values in order, according to column index. This is difficult if you want to access columns by name rather than column number.
You cannot read a column value in a row more than once.
