All Apps and Add-ons

What is the difference between Max Rows to Retrieve and Fetch Size in DBConnect 2 and how to determine what values to configure for both

reggie_123
Explorer

I can't seem to figure out the difference between those two properties.
Max Rows to Retrieve and Fetch Size in DBConnect 2.
What are they used for and how to determine what recommended values should be assigned?

Tags (1)

croissant
Explorer

Below are the differences between the two parameters:

Max Rows to Retrieve: 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.

Fetch Size: This value will be set to the JDBC driver as a hint 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.

Get Updates on the Splunk Community!

Introducing Ingest Actions: Filter, Mask, Route, Repeat

WATCH NOW Ingest Actions (IA) is the best new way to easily filter, mask and route your data in Splunk® ...

Splunk Forwarders and Forced Time Based Load Balancing

Splunk customers use universal forwarders to collect and send data to Splunk. A universal forwarder can send ...

NEW! Log Views in Splunk Observability Dashboards Gives Context From a Single Page

Today, Splunk Observability releases log views, a new feature for users to add their logs data from Splunk Log ...