https://community.splunk.com/t5/All-Apps-and-Add-ons/What-is-the-difference-between-Max-Rows-to-Retrieve-and-Fetch/m-p/216206#M23440 <P>Below are the differences between the two parameters:</P> <P><STRONG>Max Rows to Retrieve:</STRONG> This will be the rows that will retrieved with each query. Note that it depends on how each client is implemented. For instance, PostgreSQL driver seems to honor this value and limits the data from DB, therefore both DB and DBX will be limited. However, other drivers may ignore this on the DB side (not like limiting the result by using LIMIT clause of SQL) and will honor it on DBX side only. </P> <P><STRONG>Fetch Size:</STRONG> This value will be set to the JDBC driver as a <EM>hint</EM> on how many rows to be fetched one time from the database. Word "hint" is emphasized, since this also highly depends on how the database drivers are implemented. For example, Oracle drivers seems to honor this setting and try to fetch the rows in chunk, so that it can avoid from out of client side (DBX) memory errors, while some drivers might not honor it and just send the whole result in one big bulk.</P> Thu, 31 Aug 2017 06:05:30 GMT croissant 2017-08-31T06:05:30Z https://community.splunk.com/t5/All-Apps-and-Add-ons/What-is-the-difference-between-Max-Rows-to-Retrieve-and-Fetch/m-p/216205#M23439 <P>I can't seem to figure out the difference between those two properties.<BR /> Max Rows to Retrieve and Fetch Size in DBConnect 2.<BR /> What are they used for and how to determine what recommended values should be assigned?</P> Thu, 10 Nov 2016 09:00:33 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/What-is-the-difference-between-Max-Rows-to-Retrieve-and-Fetch/m-p/216205#M23439 reggie_123 2016-11-10T09:00:33Z https://community.splunk.com/t5/All-Apps-and-Add-ons/What-is-the-difference-between-Max-Rows-to-Retrieve-and-Fetch/m-p/216206#M23440 <P>Below are the differences between the two parameters:</P> <P><STRONG>Max Rows to Retrieve:</STRONG> This will be the rows that will retrieved with each query. Note that it depends on how each client is implemented. For instance, PostgreSQL driver seems to honor this value and limits the data from DB, therefore both DB and DBX will be limited. However, other drivers may ignore this on the DB side (not like limiting the result by using LIMIT clause of SQL) and will honor it on DBX side only. </P> <P><STRONG>Fetch Size:</STRONG> This value will be set to the JDBC driver as a <EM>hint</EM> on how many rows to be fetched one time from the database. Word "hint" is emphasized, since this also highly depends on how the database drivers are implemented. For example, Oracle drivers seems to honor this setting and try to fetch the rows in chunk, so that it can avoid from out of client side (DBX) memory errors, while some drivers might not honor it and just send the whole result in one big bulk.</P> Thu, 31 Aug 2017 06:05:30 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/What-is-the-difference-between-Max-Rows-to-Retrieve-and-Fetch/m-p/216206#M23440 croissant 2017-08-31T06:05:30Z