Archives of the TeradataForum

Message Posted: Fri, 10 Sep 2004 @ 17:39:56 GMT

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

We use the JDBC type 4 driver for an Enterprise Java application (JBoss)

For certain types of sql operations, such as INSERT, one conection does use one session, and many such INSERTs can hammer on just one AMP

However many connections use many sessions. Therefore if you want to distribute processing across TD nodes, you should create many Threads, each with its own Connection and Session.

We do this and on our 8-amp dev box, with 8 threads I get exactly 8x perfrormance.

John Pianezze
Telephia.

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