JDBC Request 'Max Rows' and ResultSet 'fetchSize' (3.5 Beta 1)
Is the 'Max Rows' property of the JDBC Request step supposed to affect the ResultSet 'fetchSize' in the result XML? I see the default fetchSize is 100 and I can't seem to change it.
Forum Discussion
SmartBear_Suppo
Alumni
AlumniHi,
The fetch size is the number of rows physically retrieved from the database at one time by the JDBC driver as you scroll through a query ResultSet. It improves performance by reducing the number of calls (which are frequently network transmissions) to the database, in case of large Result Sets.
For now it is only displayed in Result panel as information, with no option of changing it.
If you have any need for changing it let us know and we will consider it.
Regards,
/Dragica
eviware.com
The fetch size is the number of rows physically retrieved from the database at one time by the JDBC driver as you scroll through a query ResultSet. It improves performance by reducing the number of calls (which are frequently network transmissions) to the database, in case of large Result Sets.
For now it is only displayed in Result panel as information, with no option of changing it.
If you have any need for changing it let us know and we will consider it.
Regards,
/Dragica
eviware.com