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.
