Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SP execution in .NET is very slow
Message
 
To
25/10/2005 12:34:38
General information
Forum:
ASP.NET
Category:
Databases
Environment versions
Environment:
C# 1.1
Database:
MS SQL Server
Miscellaneous
Thread ID:
01061878
Message ID:
01062016
Views:
14
Bonnie,

I think, this cannot be the problem. This code is in middle tier and used to execute all stored procedures in the system. However, we don't have such problems with other stored procedures.
I didn't describe the code in all details. Connection property is static and returns existing SqlConnection object, if it was already created, or returns a new object from other class, as shown in my message.


>Alexander,
>
>Your code doesn't look too bad, but I wonder about the TransactionHolder.Connection property. It looks to me like you are creating a new Connection every time you access the property. I don't think this is what you want to do. Could this be the problem?
>
>~~Bonnie
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform