You can improve performance on retrieving a result set from the database if you set the
REPEAT_READ connection property to false.
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.