Understanding the Fetch and Batch sizes in EDS

Environment

• Red Hat JBoss Data Services 5.3.1
• Fetch Size as affected by the following
  • JDBC FetchSize set via JDBC API.
  • maxRowsFetchSize as defined in section B.9. Runtime Engine Deployer Settings of the Data Services Administration Guide.
  • disableResultSetFetchSize
• Batch Sizes as affected by the following
  • processorBatchSize in the BufferService bean defined in /jboss-as/server/<PROFILE>/deploy/teiid/teiid-jboss-beans.xml as detailed in the Scalability Considerations of the Data Services Administration Guide and the Buffer Service Settings.