473,624 Members | 2,278 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

slow ASP-SQL database connection

My ASP pages have very slow connections with SQL Server database, although
eventually it will reach the page and get the results. The SQL Server
database and IIS are in the same machine, I have no idea why it will cause
the problem.

I just put this connection string as SSI:

strConnect="Pro vider=SQLOLEDB. 1;Integrated Security=SSPI;P ersist Security
Info=False;Init ial Catalog=MYDATAB ASE;Data Source=MYCOMPUT ER"

Anyone has any ideas? Please advise. thanks!
John
Jul 19 '05 #1
4 7781
How are you determining that it's the connection that is slow?

John Davis wrote:
My ASP pages have very slow connections with SQL Server database,
although eventually it will reach the page and get the results. The
SQL Server database and IIS are in the same machine, I have no idea
why it will cause the problem.

I just put this connection string as SSI:

strConnect="Pro vider=SQLOLEDB. 1;Integrated Security=SSPI;P ersist
Security Info=False;Init ial Catalog=MYDATAB ASE;Data Source=MYCOMPUT ER"

Anyone has any ideas? Please advise. thanks!
John

Jul 19 '05 #2
I just migrated the database and web pages from one machine to another
machine. The speed of the original web pages are faster than the current
one.

I wonder if anything to do on IIS or SQL Server settings??

"Bob Barrows" <re*******@yaho o.com> wrote in message
news:OK******** ******@TK2MSFTN GP12.phx.gbl...
How are you determining that it's the connection that is slow?

John Davis wrote:
My ASP pages have very slow connections with SQL Server database,
although eventually it will reach the page and get the results. The
SQL Server database and IIS are in the same machine, I have no idea
why it will cause the problem.

I just put this connection string as SSI:

strConnect="Pro vider=SQLOLEDB. 1;Integrated Security=SSPI;P ersist
Security Info=False;Init ial Catalog=MYDATAB ASE;Data Source=MYCOMPUT ER"

Anyone has any ideas? Please advise. thanks!
John


Jul 19 '05 #3
I just migrated the database and web pages from one machine to another
machine. The speed of the original web pages are faster than the current
one.

I wonder if anything to do on IIS or SQL Server settings??

"Bob Barrows" <re*******@yaho o.com> wrote in message
news:OK******** ******@TK2MSFTN GP12.phx.gbl...
How are you determining that it's the connection that is slow?

John Davis wrote:
My ASP pages have very slow connections with SQL Server database,
although eventually it will reach the page and get the results. The
SQL Server database and IIS are in the same machine, I have no idea
why it will cause the problem.

I just put this connection string as SSI:

strConnect="Pro vider=SQLOLEDB. 1;Integrated Security=SSPI;P ersist
Security Info=False;Init ial Catalog=MYDATAB ASE;Data Source=MYCOMPUT ER"

Anyone has any ideas? Please advise. thanks!
John


Jul 19 '05 #4
This question cannot be answered until you verify where the slowdown is
occurring. This will require some debugging to be done with your pages. Use
Response.write' s to report on your code timing:

<%
dim t
t= now()
....
response.write datediff("s",t, now()) & "<BR>"
....
response.write datediff("s",t, now()) & "<BR>"
....

Bob Barrows

John Davis wrote:
I just migrated the database and web pages from one machine to another
machine. The speed of the original web pages are faster than the
current one.

I wonder if anything to do on IIS or SQL Server settings??

"Bob Barrows" <re*******@yaho o.com> wrote in message
news:OK******** ******@TK2MSFTN GP12.phx.gbl...
How are you determining that it's the connection that is slow?

John Davis wrote:
My ASP pages have very slow connections with SQL Server database,
although eventually it will reach the page and get the results. The
SQL Server database and IIS are in the same machine, I have no idea
why it will cause the problem.

I just put this connection string as SSI:

strConnect="Pro vider=SQLOLEDB. 1;Integrated Security=SSPI;P ersist
Security Info=False;Init ial Catalog=MYDATAB ASE;Data
Source=MYCOMPUT ER"

Anyone has any ideas? Please advise. thanks!
John


Jul 19 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
2721
by: Kurt Bauer | last post by:
I have an ASP group calendar application which pulls calendar data from Exchange via webdav into an XML string. I then loop the XML nodes to populate a collection of appointments. Finally I use the appointment collection to populate the calendar control. The performance getting the XML data is fine, but loading the data into the collection is slow. My question/problem is should I be using the collection, a dataset, or something else to...
8
2331
by: BlueBall | last post by:
I am writing some kind of network testing tool and I have wrote the following code in ASP.NET with C# int size= 10048576; // around 10 MB data string buffer = ""; for (int j=1; j<=1024; j++) { buffer = String.Concat(buffer, "x"); // I tried buffer += "x"; same performance }
8
11053
by: Soeren S. Joergensen | last post by:
Hi, From a win-service I do a HttpWebRequest to a secure url with some parameters to get some simple data from a remote system used later on in a worker thread. When making the request from my code it takes about 10-12 secs to complete, but doing same request in my browser takes less than 1 sec. Can anyone explain this delay from within my code ??
4
2158
by: Vito DeCarlo | last post by:
Over the past week, I've been noticing that any websites (on this one particular web server) built with ASP.NET have unusually slow (5 second) response times when moving through the site. There are times when the delays dissappear, but they are existent 80% of the time. This has only started up over the past week or so and I have checked CPU usage, memory usage, etc. I've also reinstalled the 1.1 version of the .NET framework just to...
3
2380
by: Pavils Jurjans | last post by:
Hello, I am experiencing very slow processing of ASP.NET pages that are served over LAN, while when running them on the server machine (ie http://localhost), there is no slowdowns. We have two desktop PCs with Windows XP Corporate ed, and one Laptop with Windows 2000 Professional. The IIS is installed on all of them. When running the ASP.NET applications from localhost, they run very smoothly. When the application is uploaded to the...
8
4251
by: aualias | last post by:
I am rewriting a web page that was previously done with ColdFusion. It has a DataGrid and one column in the DataGrid is a dropdown list which is the same for all rows. The ItemDataBound code looks like this... // _viewDestinations is created once and stored in the ViewState
5
2512
by: Ram | last post by:
Hi After deploying a simple web application to the production environment, I see that hwne I launch my app's url it takes a while to load the home page.(it doesnt do anything complex. A pretty simple adn straightforward page with just a few text boxes and a button). After that the app's response time is reasonably fast. Any idea why the response time is slow? Is it something to do with ASP.NET's engine? I noticed it in the test environment but...
10
2839
by: John | last post by:
Hi When I open a new outlook email from vb.net, sometimes outlook is very slow to appear or occasionally outlook freezes completely. I am targeting mixed office2000/xp environments so I am using the office2000 interop dlls generated by vs.net by adding office 2000 com reference. Any one else noticed this problem when targeting office2000/xp mixed environments? Is there a better, more robust way to do this? Am I better off using late...
9
13030
by: SAL | last post by:
I have an ASP.NET 2.0 app that takes about 17 seconds to load on first startup but then is very fast after that. As I understand it from some posts in June, this is caused by the loading of the App Domain. We have both Cold Fusion and ASP.NET apps on this server and the Cold Fusion apps do not display such slowness on their first start up of the day. Is there a way to improve the load times of ASP.NET apps? I'm having to justify to my boss...
6
1262
by: Cirene | last post by:
I have VS2008 and the IDE is super slow. I updated to the latest version. Is there a way to find out why it's acting so slow?
0
8242
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8681
Oralloy
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...
0
8629
jinu1996
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...
1
8341
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,...
0
7170
agi2029
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...
1
6112
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4084
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...
0
4183
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2611
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 using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.