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...
| 
