Archives of the TeradataForum
Message Posted: Wed, 08 Jan 2003 @ 20:47:03 GMT
| Subj: || || Re: NCR OLE-DB Provider for Teradata |
| From: || || Anomy Anom |
<-- Anonymously Posted: Wednesday, January 08, 2003 15:34 -->
| ||We wanted to know if using NCR's OLE DB provider would be faster than using ODBC to move data. We determined that the throughput was
about the same.|| |
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.
| ||In regards to stability, we didn't come across any errors specific to the OLE DB provider.|| |
Same here, in addition to the DTS example above, we've tested various Web apps with OLE DB and ADO and didn't get any errors.
| ||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.|| |
Take a look at NCR's documentation for the OLE DB Provider, around page 2-31. The Default Database is set in the Provider String.
Hope this helps.