[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=12654100#comment-12654100 ] 

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

Admin guide also describes a parameter called "org.teiid.ODBCPacketSize" to define the buffer size that teiid uses to batch the multiple rows into single packet that goes across the network. One could also use tools like Wireshark before and after to see the number of packets sent back and forth
                
> 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