Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 20 Jul 1999 @ 19:15:37 GMT


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


Subj:   Re: OLTP transactions
 
From:   John HR Schuster

It has been my experience that database engines can be written by the developers to do a certain task well. Informix is great at OLTP while Teradata is great at DSS. When you try to make the engine perform where is was not designed the performance is often not what you expected.

I wrote a OLTP system for a City Government and was disappointed with response times over SQLServer and Oracle I made do with what I had in the time frame and release of Teradata at the time. The newer release of Teradata are more performant in OLTP but from what I understand still not near OLTP spec's of database engines designed to do OLTP. The final outcome at the City was to use Informix (Application) for OLTP and copy data to the Teradata side for DSS work.


Just a thought...



     
  <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