Click here to Skip to main content
15,893,401 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello

I created an ASP.NET Website in .NET 4.5.

The site runs offline with all necessary things stored offline.

After a couple of people start using the site, it slows down to a halt.

I end up having to restart the server/services/iis site etc to solve the issue.

I have the site running on an IP eg: 192.168.0.150

The SQL connection uses localhost.

I am using the subnet 255.255.192.0

What could be the issue??

Any ideas?

Thanks
Posted
Comments
Mehdi Gholam 27-Jul-13 9:27am    
Obviously there is a problem in your coding and memory usage.
Boipelo 27-Jul-13 14:01pm    
Probably connection leak as it worked after restarting IIS- you are having a connection pooling problems...
Syed Shabeer 30-Jul-13 6:29am    
Use try...catch...finally to use and dispose off the objects for SQL connections. Or else use 'using' statement in order to prevent connection pooling issue.

1 solution

The issue was I forgot to put a close statement for the sql connection in one of my commands. Yea, rush coding is not the best idea :)

All sorted and running like a dream :)

Thanks guys
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900