Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 09 Jan 2003 @ 10:55:56 GMT

  <Prev Next>   <<First <Prev

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

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