[teiid-issues] [JBoss JIRA] Created: (TEIID-892) Add a capability to control bulk insert batch size

[Steven Hawkins (JIRA)]

Add a capability to control bulk insert batch size
--------------------------------------------------

                 Key: TEIID-892
                 URL: https://jira.jboss.org/jira/browse/TEIID-892
             Project: Teiid
          Issue Type: Feature Request
          Components: Connector API, Query Engine
    Affects Versions: 7.0
            Reporter: Steven Hawkins
            Assignee: Steven Hawkins
            Priority: Minor
             Fix For: 7.0


Based upon a recent customer conversation our default batching strategy to the connector may not be the most performant for large datasets.  In general our current approach limits batches to a maximum = processor batch size (default 2000).

We already have a property connector batch size, but it's across all connectors - and is mostly irrelevant since the source fetch size will have a larger impact on performance and the result batches are resized to the processor batch size anyway.  The only time connector batch size really matters is if we bring back "remote" connectors.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira