I have a webservice running which takes quit a long time to process due to complex queries to the database. It's a given the request can take up to 30-40 seconds before it returns a response. Under a high load the cpu goes up to 100% (hogged solely by w3wp.exe) and won't come back down even when...

I'm building a "media" website using ASP.NET C#. The average file size of media that members would be uploading and downloading is about 200MB. Since these are large files and user bandwith constraints will be that the thread from the threadpool will be occupied servicing these requests...