[teiid-issues] [JBoss JIRA] (TEIID-1652) ODBC Data Row results should be batched

[Ramesh Reddy (Commented) (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-1652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12654085#comment-12654085 ] 

Ramesh Reddy commented on TEIID-1652:
-------------------------------------

There is no direct way to test this outside in visible form, however when dealing with large number results the ODBC return of results is some what slow. However, if you add

Fetch                = 10000
UseDeclareFetch      = 1

configuration parameters to the DSN in the odbc.ini file, then you will see increase in performance (time it takes to start receiving the results)
                
> ODBC Data Row results should be batched
> ---------------------------------------
>
>                 Key: TEIID-1652
>                 URL: https://issues.jboss.org/browse/TEIID-1652
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: ODBC
>    Affects Versions: 7.1.1
>            Reporter: Ramesh Reddy
>            Assignee: Ramesh Reddy
>             Fix For: 7.1.1, 7.4.1, 7.5
>
>
> Teiid currently writes one row at a time into the wire to send the ODBC data rows. Since the ODBC driver is capable of reading a stream of rows, it will be performant to batch multiple rows into single buffer before they can written to the wire. This will reduce the network fragmentation and result in fewer number of round trips and helps of network latency.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira