|
Home > Archive > IIS Server > November 2004 > web pages load very slow
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
web pages load very slow
|
|
|
| Hi All,
I have a webpage that takes about 45 seconds to load
it is running a very large SQL server 2000 query. When I
run the query in Query Analyzer it takes less then 2
seconds to complete. Can any one tell me why this might
be happening?
TIA,
Joe
| |
| Jonathan Maltz [MS-MVP] 2004-09-24, 5:51 pm |
| Hi,
When you run it in query analyzer it just returns the values, but when you
run it in a web site, first you request the values from the SQL server, then
you parse it. Demand can cause slowness. Are you using ASP.NET? If so, I
suggest caching
http://msdn.microsoft.com/library/d...ingfeatures.asp
--
--Jonathan Maltz [Microsoft MVP - Windows Server - IIS, Virtual PC]
http://www.visualwin.com - A Windows Server 2003 visual, step-by-step
tutorial site :-)
http://vpc.visualwin.com - Does <insert OS name> work on VPC 2004? Find out
here
Only reply by newsgroup. I do not do technical support via email. Any
emails I have not authorized are deleted before I see them.
"JOE" <anonymous@discussions.microsoft.com> wrote in message
news:0c1701c4a268$a0722470$a501280a@phx.gbl...
> Hi All,
> I have a webpage that takes about 45 seconds to load
>
> it is running a very large SQL server 2000 query. When I
> run the query in Query Analyzer it takes less then 2
> seconds to complete. Can any one tell me why this might
> be happening?
>
> TIA,
> Joe
>
| |
|
| Hi Joe,
Did you get a reponse on this ? I have the same issue and have found no
answers.
Aleks
"JOE" <anonymous@discussions.microsoft.com> wrote in message
news:0c1701c4a268$a0722470$a501280a@phx.gbl...
> Hi All,
> I have a webpage that takes about 45 seconds to load
>
> it is running a very large SQL server 2000 query. When I
> run the query in Query Analyzer it takes less then 2
> seconds to complete. Can any one tell me why this might
> be happening?
>
> TIA,
> Joe
>
|
|
|
|
|