|
|
Archives of the TeradataForum
Message Posted: Tue, 20 Jul 1999 @ 17:45:07 GMT
Subj: | | OLTP transactions |
|
From: | | Bob Maccione |
Hi, we're playing with the database and testing the OLTP performance. Currently it seems rather dismal, where we are looking for
subsecond response time we're getting a couple seconds response time. Has anyone gotten subsecond performance (on a single query, via
index), yea, it's a trick question but it just seems that the open, fetch, close performance isn't all that fast. However I do acknowledge
that the OLAP performance is amazing (My background is more Informix than Teradata so I was skeptical at first).
Thanks for any insights,
Bob Maccione
| |