Understanding the Fetch and Batch sizes in EDS - Red Hat Customer Portal

Log in to Your Red Hat Account

Your Red Hat account gives you access to your profile, preferences, and services, depending on your status.

If you are a new customer, register now for access to product evaluations and purchasing capabilities.

Need access to an account?

If your company has an existing Red Hat account, your organization administrator can grant you access.

If you have any questions, please contact customer service.

Red Hat Account Number:

Red Hat Account

Customer Portal

For your security, if you’re on a public computer and have finished using your Red Hat services, please be sure to log out.

Select Your Language

Issue

What are the client options for specifying a batch size?
What is the server processor batch size?
What does org.teiid.disableResultSetFetchSize do?
What is a working batch size?
What is a result set fetch size?

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.

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.

Here are the common uses of Markdown.

Code blocks

~~~
Code surrounded in tildes is easier to read
~~~

Links/URLs

[Red Hat Customer Portal](https://access.redhat.com)