Archives of the TeradataForum
Message Posted: Thu, 06 Dec 2001 @ 06:04:29 GMT
| Subj: || || Re: WinCLI vs. ODBC |
| From: || || Todd Walter |
For results return, Teradata ODBC driver transfers blocks the same way that CLI does. If result sets are being returned that are larger
than a few rows, the ODBC buffer size parameter should be tuned to its maximum size, this will make a significant difference in result
For insert/update operations, neither ODBC or CLI batchthe updates automatically. That must bedone in a program. If Access is used to
insert or update a large number of rows, access will send the rows a row at a time through ODBC which will circumvent all of Teradata's
parallelism. If large numbers of rows are to be inserted or updated, the utilizing the appropriate Teradata utility is indicated.
It is Teradata's strategic intent that ODBC and CLI perform equivalently. We would always recommend ODBC as the appropriate open
interface to use for new applications on platforms other than the mainframe.