 |
 |
Archives of the TeradataForum
Message Posted: Thu, 09 Jan 2003 @ 10:55:56 GMT
| Subj: | | Re: NCR OLE-DB Provider for Teradata |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Wednesday, January 08, 2003 18:04 -->
| | Not a very scientific counter-example, but we tested 2 'Create Table ... With Data' statements via a DTS package on
SQLServer2K with the ODC and OLE DB drivers. They weren't large tables (about 42k rows), but the process using ODBC (v. 2.08.02)
took about 1.5 hours, while the same process using OLE DB (Release 1.0) took just under 1 hour. | |
Did both the ODBC and OLE DB have the same settings. For example was the Max Response Buffer Size set to 65477 (Max allowed) on
both ODBC and OLE DB. This can have a big difference when returning alot of records (000's)
| | One nagging problem (and this could be due to our lack of knowledge) was the inability to define a default database
using the OLE DB provider. | |
All the settings you get within ODBC and more are hidden within the Provider String, including the value for the response buffer
size, default database, session mode etc
| |
