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 3 1889
I would start by trying to identify the bottleneck - from what you've
said, it's not clear if this is an MSSQL issue. If I understand you,
both you and the other users are hitting the same IIS server, and
issuing the same queries, but they get the results slowly and you
don't. That could suggest that the delay is in serving the pages to the
remote users, not in retrieving the data from the database.
You can use the MSSQL Profiler to check the duration and execution plan
of your queries, to see if there's any difference depending on the user
requesting the data. If there is a difference, then hopefully the
execution plan will give you a clue as to where the problem is.
You might also want to post in an ASP/IIS group, if you haven't already
done so - many performance problems aren't due to only one issue, so
getting some ideas about how to investigate the other components of the
system would probably be useful.
Simon
Hi Simon,
I did some debugging, and it took SQL Server the same about of time to
do complete the query for both local and interstate, and it's the
serving of the page that is definitely taking much longer on our
interstate servers.
Usually, most users would do a query that should return about 1000+
records, and than these records gets displayed into a table on the asp
page. The page (file size) itself is roughly around 110+kB, so it's not
exactly a BIG file to be tranferred. But then why the slow down?
Any advices/ideas on how to by-pass this problem?
Regards,
Shawn
Simon Hayes wrote: I would start by trying to identify the bottleneck - from what you've said, it's not clear if this is an MSSQL issue. If I understand you, both you and the other users are hitting the same IIS server, and issuing the same queries, but they get the results slowly and you don't. That could suggest that the delay is in serving the pages to
the remote users, not in retrieving the data from the database.
You can use the MSSQL Profiler to check the duration and execution
plan of your queries, to see if there's any difference depending on the
user requesting the data. If there is a difference, then hopefully the execution plan will give you a clue as to where the problem is.
You might also want to post in an ASP/IIS group, if you haven't
already done so - many performance problems aren't due to only one issue, so getting some ideas about how to investigate the other components of
the system would probably be useful.
Simon
"Shawn H" <Sh*********@gmail.com> wrote in message
news:11********************@z14g2000cwz.googlegrou ps.com... Hi Simon,
I did some debugging, and it took SQL Server the same about of time to do complete the query for both local and interstate, and it's the serving of the page that is definitely taking much longer on our interstate servers.
Usually, most users would do a query that should return about 1000+ records, and than these records gets displayed into a table on the asp page. The page (file size) itself is roughly around 110+kB, so it's not exactly a BIG file to be tranferred. But then why the slow down?
Any advices/ideas on how to by-pass this problem?
Regards, Shawn
<snip>
No idea, unfortunately. Since the problem seems to be serving the pages,
you'll probably get better assistance in an IIS/ASP group.
Simon This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: NEtsdpace news |
last post by:
I've developed an Intranet app that among other things creates form letters
using a VB dll, via a cab file, to access Word functions. It works perfectly
and performs well when asked to create the...
|
by: mrwoopey |
last post by:
Hi,
I am using the OLAP data cube in a web browser (using the code from
the SQL 2000 toolkit). The OLAP services is on database server and the
web interface is on the web server. If we do simple...
|
by: Rob R. Ainscough |
last post by:
This is more of a conceptual question:
1. More and more companies are using VPN's and locking out internet
connectivity (for a host of reasons, security, productivity, etc.).
2. ASP.NET...
|
by: Pascal Gineste |
last post by:
Hello,
I try to find information related to the performance problem we encountered on
this newgroups, but I didn't find any solution, whereas it seems that we are
not the only one who met this...
|
by: Scott F. Brown |
last post by:
Hello all,
I am attempting to work on a project for work at home and I'm experiencing
extremely slow page loads. These are pages that work fine in the office but
when I try to work on the...
|
by: Rich |
last post by:
This new website purchased for our non-profit has a drop menu
has 13 starting points and around 230 individual links, that
appears on every page in the site, using ".asp" technology.
Know where...
|
by: abcd |
last post by:
I have web applicaiton writting in asp.net 1.1. When the first page loads it
loads the data only in 2 controls. The data is poped upo by acooneting to
access DSN and using ODBCConnection and...
|
by: mark4asp |
last post by:
Why is this page so slow to render in Internet Explorer?
<http://mark4asp.freehostingnow.com/Search.html>
When browsing the page locally, this is my estimated time that the
page takes to...
|
by: DolphinDB |
last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation.
Take...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |