Re: Poor performance under IIS

"Ilyas" <ilyas@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:365096f7-a1ca-4f4d-90e1-45e9fa7e75ea@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

I have an application which brings back 1000 records from a sql server
database. Under the local asp.net development server provided with
Visual Studio 2008, it takes about 1.8 seconds

When I place this application in IIS it takes 16 seconds for the exact
bit of code. I have narrowed the code down to loopoing around the
dataset and creating an object for every row in the dataset. My
question is why does it take so long under IIS but not under the local
asp.net development server?

Any ideas? How can I get this 16 seconds down to a more acceptable
level eg 2-3 seconds? Is this a configuration issue? I have tried
deploying this to 2 different IIS servers and the same bit of code
takes 16 seconds on both IIS boxes

1) When the code is running on the development server, is the database it's connecting to also on the development server?

2) When the code is running on the remote server, is the database it's connecting to on a different remote server? If so, have you got networking issues. Also, what database is it and how are you connecting to it?

3) Can you be a bit more specific about what you mean by "looping around the dataset"? What is actually happening here?

4) Can you confirm that, wherever the bottleneck is, it's not in the actual retrieval of the data from the database...?


--
Mark Rae
ASP.NET MVP
http://www.markrae.net

.

Relevant Pages

  • IIS 6.0 vs IIS 5.1
    ... My web project runs on machine (local host) successfully. ... development server and I met a lot of troubles. ... an instruction is satisfied it will update database. ... Here are some infos of the development server (IIS) ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: IIS 6.0 vs IIS 5.1
    ... > development server and I met a lot of troubles. ... > update the database with empty parameter (in my database require these ... > 3> Support access database and others. ... > 2> Checking for the version of IIS and make sure we have identical ...
    (microsoft.public.dotnet.framework.aspnet)
  • Poor performance under IIS
    ... database. ... Under the local asp.net development server provided with ... Visual Studio 2008, ... When I place this application in IIS it takes 16 seconds for the exact ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Addinga 2nd content database with possible site name collision
    ... thinking about it I went and checked the development server and it has ... two sites defined as \ in the same config database. ... so / (root) is the same regardless of what ...
    (microsoft.public.sharepoint.windowsservices)
  • Oracle server partitioning strategy
    ... The database will be Oracle 9i. ... It is a development server and will also host ... advisable to mirror at the partition level with Solaris 9, ...
    (comp.unix.solaris)