[teiid-issues] [JBoss JIRA] (TEIID-1652) ODBC Data Row results should be batched
[
https://issues.jboss.org/browse/TEIID-1652?page=com.atlassian.jira.plugin...
]
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