Groups > Web Hosting > IIS Administration and configuration > Re: IIS 5.1 Windows XP - ASP.Net 1.1 DB queries very slow




IIS 5.1 Windows XP - ASP.Net 1.1 DB queries very slow

IIS 5.1 Windows XP - ASP.Net 1.1 DB queries very slow
Mon, 24 Jul 2006 21:49:25 +000
Hi:

I recently got a new development machine (Dell Inspiron, centrino 1.6mhz, 1 gb
ram) .  I setup IIS and installed VS.Net 2003.  

I am experiencing very sluggish performance whenever I browse asp.net pages on
my localhost that make queries to the database.  However, this is not the case
when I publish the site to other servers.  Every page loads very quickly.

One example is page that contains a single dropdown list.  Running this page
locally on my machine takes over 14s to load, but less than 1s in the test
environment.  The query is very simple and returns only 10 results.  

When debugging my code I don't have a problem with the following lines...

conn = new sqlconnection(strConn)

conn.open()

Its seems to get hung up when the actually query is being called....
cmd.ExecuteReader()

Is there some configuration settings in IIS / asp.net that I possible did not
set correctly?  I don't believe that this performance has as much to do with the
application itselft, but more to do with my localhost environment.

Any suggestions will be greatly appreciated.  Thanks.
Post Reply
Re: IIS 5.1 Windows XP - ASP.Net 1.1 DB queries very slow
Mon, 24 Jul 2006 23:20:11 +000
Nothing in IIS controls this.  Low memory can cause this, as can issues with
your database configuration.  Drive speed, system speed, all come into play.

Jeff
Post Reply
Re: IIS 5.1 Windows XP - ASP.Net 1.1 DB queries very slow
Tue, 25 Jul 2006 12:19:15 +000
... you may get a better response in the ASP.NET data related forum ...
Post Reply
about | contact