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 1910
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*********@gm ail.com> wrote in message
news:11******** ************@z1 4g2000cwz.googl egroups.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 Word documents.
However my problem is that it takes >30 seconds for the initial page to
display. If I comment out the "<OBJECT>" definition and as a consequence
all lines/function referencing that object, the page displays <3 seconds.
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 queries on the
cube, it works fine. When we do complex queries the cube in the web
browser loads very slow or errors. Also, I noticed that when it is
building the output for the cube (the display) that most of the
processing is taking place on...
|
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 requires a web server and has more layers than a .NET Windows
application
3. a .NET windows app .DLL's and .EXEs are very small
So which is better, offer a Windows .NET component ("managed") that can be
downloaded installed from a web site or...
|
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 problem described below:
Configuratrion IIS5 locally instally on each developper platform W2K
VS.net 2003
if we create a single .aspx page and we launch this page from IE, it took
|
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 project at home on my laptop, the pages take
upwards of 100+ seconds to load. I will try to give all the pertinent info
below. I think it is probably a security issue which is why I am cross
posting.
My laptop is acting as my web server. I am...
| |
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 can we find info / syntax for this mm_menu.js system
that appears to be a derivative of Fireworks? And, is this the
latest revision? Believe is derivative of Macromedia Fireworks.
Preamble in the controlling .js file says:
/**
|
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 executereader. With simple queries
like
Select Title, Name from Table1 order by Titlle
Why the page loads very slowly when I request the page it takes almost 20-30
seconds to display the page. I am novice .net developer (basically, I am
classic...
|
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 refresh using various browsers:
Safari ~ 0.2 s
Firefox < 1s
Opera ~ 1s
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |