Archives of the TeradataForum
Message Posted: Tue, 20 Jul 1999 @ 19:15:37 GMT
| 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...
| 
