Terada ADODB performance issue.

Connectivity
N/A

Terada ADODB performance issue.


I am a loadtester test on of my groups and notice that the create Object method is not scaling. I am lucky to get 10 users running and response times are taking over a minute to create. Any ideas what could be taking so long?

I am trying to run a test of 30 concurrent users against a teradata odbc driver with the following method below. What is happening is we are getting Intermittent high response times trying to connect. Is there a better method to use?

Dim strId, strPW, strDSN
Dim objConnection
set objConnection = Server.CreateObject("ADODB.Connection")
strId = "XXXXXX"
strPW = "XXXXXX"
strDSN = "TERA07"
' -------------------
objConnection.ConnectionTimeout = 180
' -------------------
objConnection.Open strDSN, strId, strPW
3 REPLIES
N/A

Re: Terada ADODB performance issue.

Are you using ASP or VB6 ?.
Anyway try this out...

Dim strId, strPW, strDSN
Dim strConn as String
Dim objConnection as ADODB.Connection
set objConnection = New ADODB.Connection
strId = "XXXXXX"
strPW = "XXXXXX"
strDSN = "TERA07"
strConn = "DSN=" & strDSN & ";Uid=" & strId & ";Pwd=" & StrPW & ";"
' -------------------
objConnection.ConnectionTimeout = 180
' -------------------
objConnection.Open strConn
Teradata Employee

Re: Terada ADODB performance issue.

If it's the Connect method that's taking too long, be sure you have the latest version of the driver and particularly the latest version of the shared TeraGSS component.

Name resolution (DNS) may also be at fault. Test using a numeric IP address to rule that out.
Teradata Employee

Re: Terada ADODB performance issue.

What version of ODBC driver you have installed ?