Use Custom Fetch Size
7 May, 2013
Hi.
I cannot find an explanation of the "Use Custom Fetch Size" option in the Data Source Connection page.
What are the implications of using or not using this option? Is it simply to limit the rows returned by any single query against this source?
I don't want my query resultset limited. My query will define those limits.
Please clarify this option and I suggest you update your guide too.
Thanks in advance.
I cannot find an explanation of the "Use Custom Fetch Size" option in the Data Source Connection page.
What are the implications of using or not using this option? Is it simply to limit the rows returned by any single query against this source?
I don't want my query resultset limited. My query will define those limits.
Please clarify this option and I suggest you update your guide too.
Thanks in advance.
Hi Chris,
Fetch Size is an option of the standard JDBC specification, it determines the number of rows to fetch from the database in each page. In other words, it doesn't determine the maximum number of rows (this can set elsewhere in the Data Source configuration as described in point 2 of this Wiki Link) per query, but rather, per Fetch. For example, If the Fetch Size is 1 row, and the Maximum Row Limit for the Data Source is 1000, then there will be 1000 fetches back and forth of 1 row each.
So, in reference to what you have said, it won't limit your query result set.
Regards,
Dave
Fetch Size is an option of the standard JDBC specification, it determines the number of rows to fetch from the database in each page. In other words, it doesn't determine the maximum number of rows (this can set elsewhere in the Data Source configuration as described in point 2 of this Wiki Link) per query, but rather, per Fetch. For example, If the Fetch Size is 1 row, and the Maximum Row Limit for the Data Source is 1000, then there will be 1000 fetches back and forth of 1 row each.
So, in reference to what you have said, it won't limit your query result set.
Regards,
Dave