Hi....
I need the following information on ResultSet very urgently. can someone pls help me or let me know where can I get this info?
1). We can use SetFetchsize() to datasize to be retrieved from Result Set at one shot. When we use SetFetchSize(1024) and the there are only 10 records in ResultSet, what is the impact?
2). If we use the following to set the FetchSize equal to the number of rows and bring back cursor for fetching in normal, any impact on time?
rs.last()
nRows=rs.getRow();
rs.setFetchSize(nRows);
rs.beforeFirst();
while(rs.next())
{
....
}
3). If we set FETCH_FORWARDONLY, any gain in the execution speed
4). Any other features in JDBC2.0 that can improve performance?
5). Setting FetchSize same as RowCount(select count(*) from table), is it optimal?
also if u know any web sites or books I can refer to this pls pls let me know...
Thanx in advance!
Regards,
Gayathri.
I need the following information on ResultSet very urgently. can someone pls help me or let me know where can I get this info?
1). We can use SetFetchsize() to datasize to be retrieved from Result Set at one shot. When we use SetFetchSize(1024) and the there are only 10 records in ResultSet, what is the impact?
2). If we use the following to set the FetchSize equal to the number of rows and bring back cursor for fetching in normal, any impact on time?
rs.last()
nRows=rs.getRow();
rs.setFetchSize(nRows);
rs.beforeFirst();
while(rs.next())
{
....
}
3). If we set FETCH_FORWARDONLY, any gain in the execution speed
4). Any other features in JDBC2.0 that can improve performance?
5). Setting FetchSize same as RowCount(select count(*) from table), is it optimal?
also if u know any web sites or books I can refer to this pls pls let me know...
Thanx in advance!
Regards,
Gayathri.