Archives of the TeradataForum

Message Posted: Thu, 12 Jul 2001 @ 22:39:12 GMT

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

Hi Audrey, and all interested in OLTP.

You have gotten good advice already. A couple of other things that can help your use of Teradata for OLTP work.

1. Use macros. If you have a true OLTP application you will have the same requests repeated often. Macros which are repeated will be parsed and kept in cache so that the query plan doesn't have to be recompiled again and again. You will pass less data across the channel/network as well since you will not pass the entire SQL statement, just the macro name and parameters.

2. Use CLI-V2 to access the system rather than ODBC. Your applications will be more comlex, but the speed difference will be worth the effort for OLTP.

3. If your application needs data from more than one table, and will access each separately, rather than through a join, code your macros to do multi-statement requests. This additional parallelism will reduce the amount of hand shaking across the network or channel.

4. If your application is running on a mainframe, take advantage of session pooling. By having a session pool of already logged on sessions you don't have to wait on logon time. Unfortunately, I don't believe this is an option for network hosts.

5. Use multiple sessions to do more work in parallel if possible.

6. Monitor performance and response times, and spend your effort on the macros used the most.

I hope these ideas help. Others may have additional suggestions for ways to squeeze performance out.

Sam Mosley
President VLDB Systems, Inc.
Teradata Certified Master

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