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
4 Replies
- Hi,
The "Max Rows" property value is used for setting Sql Statement maxRows, i.e. it specifies max number of rows to be displayed in Results panel and if not specified complete sql result will be displayed.
Regards,
/Dragica
eviware.com - Thanks. Can you tell me what the fetchSize attribute means?
- Hi,
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 - As long as the number of rows that can actually be retrieved is unaffected, I probably would not worry about it, but it's always good to have options
