Hi
I've an asp.net, c#, sql server website and the volumes are starting to
rise quickly. I've been asked to look at improving the memory usage of
the application. I've not looked at this before so these are probably
naive questions:
1. If I close the sql connection every time do I need to close or
dispose of the dataset, command or any other objects?
2. Should I use data adaptor instaed of dataset?
3. Are there any other objects that I should close or dispose, or just
reply on the garbage collector?
4. How can I check for memory leaks and what are the most likely
culprits?
Any suggestions to get me up to speed in this would be greatly
appreciated.
John South
Pangbourne
www.WhereCanWeGo.com