 |
 |
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
| |
