ASP + SQL Makes Page Load Really Slow

Hi guys,


I've created a web application using ASP together with SQL Server as
our db source, running through IIS 6 on a Winows Server 2003 platform.


This application retrieves a list of customer codes from our db, so
records returned could be as many as 2000+ for any single transaction.


The application runs fine for users from the same state. However, our
interstate colleagues have notice that it takes more than 3-4mins for
the page to load, while it only takes me < 2secs to load.


Our intranet server is located in the same state as I, so anyone from
within this state has no problems loading the page. All other states
are finding it unbearable.


I've done some debugging, and it appears to be a server factor.
I saved the page with the longest list to a local drive and opened it
locally in IE and it loads quickly.


Does anyone have any suggestions as to how to speed this application up

for our interstate users?
Any ideas would appreciated.


Thanks,
Shawn

Re: ASP + SQL Makes Page Load Really Slow

Shawn H wrote:
> Hi guys,
>
>
> I've created a web application using ASP together with SQL Server as
> our db source, running through IIS 6 on a Winows Server 2003 platform.
>
>
> This application retrieves a list of customer codes from our db, so
> records returned could be as many as 2000+ for any single transaction.
>
>
> The application runs fine for users from the same state. However, our
> interstate colleagues have notice that it takes more than 3-4mins for
> the page to load, while it only takes me < 2secs to load.
>
>
> Our intranet server is located in the same state as I, so anyone from
> within this state has no problems loading the page. All other states
> are finding it unbearable.
>
>
> I've done some debugging, and it appears to be a server factor.
> I saved the page with the longest list to a local drive and opened it
> locally in IE and it loads quickly.
>
>
> Does anyone have any suggestions as to how to speed this application
> up
>
> for our interstate users?
> Any ideas would appreciated.
>
>

It sounds like a network/hardware issue to me. You need a bigger pipeline to
the users in the other states.

In the meantime, rewrite the page so you don't send all the records at once.
I.E., use paging. See

http://www.aspfaq.com/show.asp?id=2120
http://www.aspfaq.com/show.asp?id=2352
http://www.aspfaq.com/show.asp?id=2424

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: ASP + SQL Makes Page Load Really Slow

If the problem is not network bandwidth (see bob's post, are they using a
dialup connection maybe?) then you need to determine what is different for
out of state users. Are they pulling different data? From different tables?
Using different (or no) indexes?

--
--Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com

"Shawn H" wrote in message
news:1112935373.468971.78060@g14g2000cwa.googlegroups.com...
> Hi guys,
>
>
> I've created a web application using ASP together with SQL Server as
> our db source, running through IIS 6 on a Winows Server 2003 platform.
>
>
> This application retrieves a list of customer codes from our db, so
> records returned could be as many as 2000+ for any single transaction.
>
>
> The application runs fine for users from the same state. However, our
> interstate colleagues have notice that it takes more than 3-4mins for
> the page to load, while it only takes me < 2secs to load.
>
>
> Our intranet server is located in the same state as I, so anyone from
> within this state has no problems loading the page. All other states
> are finding it unbearable.
>
>
> I've done some debugging, and it appears to be a server factor.
> I saved the page with the longest list to a local drive and opened it
> locally in IE and it loads quickly.
>
>
> Does anyone have any suggestions as to how to speed this application up
>
> for our interstate users?
> Any ideas would appreciated.
>
>
> Thanks,
> Shawn
>

Re: ASP + SQL Makes Page Load Really Slow

I think it's a network bandwidth issue, or the serving of the ASP page
that is the bottleneck.

I suppose paging could be an option, but I'd rather leave that as my
last option, simply because I'm going to allow our users to change the
customer codes later on, and I don't wanna make the form too
complicated.

Do you guys have any other suggestions that I could implement to work
around this issue?

Thanks for the helps so far guys ...

Regards,
Shawn


Mark Schupp wrote:
> If the problem is not network bandwidth (see bob's post, are they
using a
> dialup connection maybe?) then you need to determine what is
different for
> out of state users. Are they pulling different data? From different
tables?
> Using different (or no) indexes?
>
> --
> --Mark Schupp
> Head of Development
> Integrity eLearning
> www.ielearning.com
>
> "Shawn H" wrote in message
> news:1112935373.468971.78060@g14g2000cwa.googlegroups.com...
> > Hi guys,
> >
> >
> > I've created a web application using ASP together with SQL Server
as
> > our db source, running through IIS 6 on a Winows Server 2003
platform.
> >
> >
> > This application retrieves a list of customer codes from our db, so
> > records returned could be as many as 2000+ for any single
transaction.
> >
> >
> > The application runs fine for users from the same state. However,
our
> > interstate colleagues have notice that it takes more than 3-4mins
for
> > the page to load, while it only takes me < 2secs to load.
> >
> >
> > Our intranet server is located in the same state as I, so anyone
from
> > within this state has no problems loading the page. All other
states
> > are finding it unbearable.
> >
> >
> > I've done some debugging, and it appears to be a server factor.
> > I saved the page with the longest list to a local drive and opened
it
> > locally in IE and it loads quickly.
> >
> >
> > Does anyone have any suggestions as to how to speed this
application up
> >
> > for our interstate users?
> > Any ideas would appreciated.
> >
> >
> > Thanks,
> > Shawn
> >

Re: ASP + SQL Makes Page Load Really Slow

If it is a network bandwidth problem your choices are to increase bandwidth
or send less data.

First you need to determine if it is a bandwidth problem. Set up a bandwidth
test page (this can be a simple as a page with a large image file on it, for
examples search the web for "bandwidth test") and have a user who
experienced the problem hit the page. Have them time the download of the
image. Meanwhile, monitor your server to make sure it is not bogged down
during the test.

--
--Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com

"Shawn H" wrote in message
news:1113174958.112922.113800@z14g2000cwz.googlegroups.com.. .
>I think it's a network bandwidth issue, or the serving of the ASP page
> that is the bottleneck.
>
> I suppose paging could be an option, but I'd rather leave that as my
> last option, simply because I'm going to allow our users to change the
> customer codes later on, and I don't wanna make the form too
> complicated.
>
> Do you guys have any other suggestions that I could implement to work
> around this issue?
>
> Thanks for the helps so far guys ...
>
> Regards,
> Shawn
>
>
> Mark Schupp wrote:
>> If the problem is not network bandwidth (see bob's post, are they
> using a
>> dialup connection maybe?) then you need to determine what is
> different for
>> out of state users. Are they pulling different data? From different
> tables?
>> Using different (or no) indexes?
>>
>> --
>> --Mark Schupp
>> Head of Development
>> Integrity eLearning
>> www.ielearning.com
>>
>> "Shawn H" wrote in message
>> news:1112935373.468971.78060@g14g2000cwa.googlegroups.com...
>> > Hi guys,
>> >
>> >
>> > I've created a web application using ASP together with SQL Server
> as
>> > our db source, running through IIS 6 on a Winows Server 2003
> platform.
>> >
>> >
>> > This application retrieves a list of customer codes from our db, so
>> > records returned could be as many as 2000+ for any single
> transaction.
>> >
>> >
>> > The application runs fine for users from the same state. However,
> our
>> > interstate colleagues have notice that it takes more than 3-4mins
> for
>> > the page to load, while it only takes me < 2secs to load.
>> >
>> >
>> > Our intranet server is located in the same state as I, so anyone
> from
>> > within this state has no problems loading the page. All other
> states
>> > are finding it unbearable.
>> >
>> >
>> > I've done some debugging, and it appears to be a server factor.
>> > I saved the page with the longest list to a local drive and opened
> it
>> > locally in IE and it loads quickly.
>> >
>> >
>> > Does anyone have any suggestions as to how to speed this
> application up
>> >
>> > for our interstate users?
>> > Any ideas would appreciated.
>> >
>> >
>> > Thanks,
>> > Shawn
>> >
>