It's seems not to be a performance problem. I have created specific index on my target table. Of course i will look about a new class dedicated to create connection and maintain connection.
The problem, i think, is that connection will be instantiated but, whenever we have delay in result retrieving, all the other connection request are queued and my asp server will not serve them. And when this connection queue became too long no...
eboschi
Last Activity: Jan 3 '08, 05:13 PM
Joined: Jan 3 '08
Location:
-
Big Database Connection Problem with ASP .NET
Hi all, i'm new to .net programming and i have some problems with database connection. I have written two web application. Both of them use ADODB Connection to Sql Server 2000 database. The problem is in second one.
The first application is used for order management. I have defined in Main.aspx page a variable called localSqlConnect ion. Every time i enter this page (only one time per session) i create connection to local database and...
No activity results to display
Leave a comment: