While consuming web service the IIS is throwing out of memory exception. It is a Data driven application where the service is reading 100 MB (aaprox.) of data from data base and sending it to the client. We are using IIS 6.0, 2003 Server with 2 GB Memory. For increasing performance we have implemented...

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...