InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How Do I Retrieve A Whole Row Of Data At Once, Instead Of Calling An Individual Resultset.getxxx Method For Each Column? |
|
Answer» The ResultSet.getXXX methods are the only way to retrieve data from a ResultSet object, which MEANS that you have to make a method call for each column of a ROW. It is unlikely that this is the cause of a performance problem, however, because it is difficult to see how a column could be fetched without at least the COST of a FUNCTION call in any scenario. We welcome input from developers on this issue. The ResultSet.getXXX methods are the only way to retrieve data from a ResultSet object, which means that you have to make a method call for each column of a row. It is unlikely that this is the cause of a performance problem, however, because it is difficult to see how a column could be fetched without at least the cost of a function call in any scenario. We welcome input from developers on this issue. |
|