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

Thu May 6 22:38:05 EDT 2010

     [ https://jira.jboss.org/jira/browse/TEIID-892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Hawkins updated TEIID-892:
--------------------------------

    Fix Version/s: 7.1
                       (was: 7.0)


pushing to 7.1

> 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.1
>
>
> 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