Archives of the TeradataForum

Message Posted: Thu, 03 Nov 2005 @ 15:21:32 GMT


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

Subj:		Introduction, Issue, Debates, concerns.

From:		Frenton, Dustin J.

I'm a .NET architect who works with Teradata pretty much on a daily basis. However I only develop against it. I have a couple questions on what individuals think of this scenario.

I am developing an application that is making around 50 separate calls to TeraData to retrieve information. My concern is that our Teradata team does not use any sort of connection pooling.

So this becomes 50 connections and 50 calls.. We are having performance issues with the macro. It takes approximately 3-6 seconds to run the macro, then added in with 50 calls... needless to say. The users are waiting quite a long time for their page to load.

I am using OleDB drivers, and Integrated authentication..

Any thoughts? Should this not be an issue?