[
https://issues.jboss.org/browse/TEIID-1652?page=com.atlassian.jira.plugin...
]
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