Archives of the TeradataForum
Message Posted: Thu, 17 Jun 2004 @ 19:34:35 GMT
I have a couple of question related to tactical queries and a persistent DB connection.
We have a client-side SOAP\XML application that makes us of a .Net Web Service application. This .Net Web Service application takes that initial query, opens a web service instance, connects to Teradata using ODBC, uses several Teradata Stored Procedures, expanding on the query, and returns the result set to the SOAP\XML application.
We have been experiencing some time-out issues and it appears that the logon to TD for each instance in the web service may be part of the problem. We were wondering if anyone has any quick logon tricks or knows of a way to keep an instance of the web service open and process all queries through that instance - a persistent connection - but - from what I understand, this is the way the web service works - it creates a new instance each time?
Also, we have an account priority for the .net application logon account such that it has a PSF priority weighting only slightly lower than the highest priority of our system resource partition - the way it should be. We were wondering if it is not getting a chance to really make use of this tactical PSF weighting - considering that it must logon each time.
Any help would be much appreciated.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|