ADVICE WANTED: Website Performance Issues

kwilliams · December 13th, 2005, 10:50 AM

I'd like to get some good advice about our old ASP site. You can see our home page at:
http://www.douglas-county.com/

...and an example application page at:
http://www.douglas-county.com/employ...topenings2.asp

Our old site uses classic ASP with JavaScript syntax. I'm in the process of developing a new site that uses XML/XSLT/CSS/ASP.NET/VB.NET, but in the meantime, we still have our old site up. It contains a lot of applications that use SQL Server 2000 data, and we're having some major performance issues.

I already know that one issue is the use of tables for formatting, and I'm already correcting that problem by using CSS Positioning with my new site. Besides that, here are some of the issues that we're having:

Different Browser Issues?
The site loads much quicker for me in Mozilla Firefox than it does in IE 6.0 for some reason. If this difference is an obvious sign of something, I'd love to know what that could be.

Connection Issues?
I've looked into whether this problem could be due to "leaky connections", but this is how I have my connections set up:

Code:

<%@language="javascript"%>
<%
var MM_strConn_STRING = "Provider=SQLOLEDB;Server=SERVERNAME;Database=DBNAME;UID=UID;PWD=PWD"
%>
<%
var Recordset1 = Server.CreateObject("ADODB.Recordset");
Recordset1.ActiveConnection = MM_strConn_STRING;
Recordset1.Source = "SELECT *  FROM dbo.tblTABLENAME";
Recordset1.CursorType = 0;
Recordset1.CursorLocation = 2;
Recordset1.LockType = 3;
Recordset1.Open();
var Recordset1_numRows = 0;
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<body>...</body>
</html>
<%
Recordset1.Close();
%>

The reason I'm looking at this as a possible cause is because my Network Administrator states that when he restarts the SQL Server, the site loads quicker. Then over time, it seems to get bogged down until the server is restarted again. It loads much slower for some users than others for some reason, and that's when they have the same browser version.

Ok, that's it. If there are any other obvious causes of this issue, please let me know. Any constructive criticism would be greatly appreciated. Thanks.

KWilliams

audio-catalyst · December 19th, 2005, 03:27 PM

dear kwilliams,

instead of using servername, use the ipadress.
instead of using a wildcart (*) use the actual column names, this should speed up your query's.
don't forget to empty out your record set ( in vb script this would be set Record1 = nothing)

make sure your connection are actually close ( you should be able to check this using Enterprise manager

"They say if you play a Microsoft CD backwards, you hear satanic messages. Thats nothing, cause if you play it forwards, it installs Windows."

kwilliams · December 19th, 2005, 04:13 PM

Quote:

quote:instead of using servername, use the ipadress.
instead of using a wildcart (*) use the actual column names, this should speed up your query's.
don't forget to empty out your record set ( in vb script this would be set Record1 = nothing)

make sure your connection are actually close ( you should be able to check this using Enterprise manager

Thanks for all of the useful suggestions. I've already followed a few of them shortly after my initial post, like making sure that all of the recordsets are emptied and making sure that the connections are closed. And I'll make sure to use your suggestion of using the column names on queries instead of the standard * wildcard. Thanks again for the suggestion, and have a great week.

KWilliams