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