Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 05 Dec 2000 @ 07:37:32 GMT


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


Subj:   Re: OLE-DB
 
From:   John K. Wight

Yes, the NT system that you execute your ETL processes with OLE-DB is sensitive to the System (speed, memory, LAN speeds, traffic, etc.). Before anyone asks, I DO NOT have any official recommendations other than that, at our customer, the work with dedicated servers with a goodly amount of memory and dual processors. We schedule and run multiple (parallel) streams from one server, but (again) are limited with Network speeds and throughput. Compared to the SQL Server environment where they were using SQL Server 7 with DTS processes, we are 3-5 times faster, specially with larger data sets. Just an FYI - hope it helps.


JK
John K. Wight
Senior Solutions Consultant - Teradata Solutions Group
NCR Corp. - Arizona Territories



     
  <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: 27 Dec 2016