Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 08 Jan 2003 @ 20:47:03 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: NCR OLE-DB Provider for Teradata
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, January 08, 2003 15:34 -->

Claybourne wrote:

  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.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020