Slow Site
I'm working on a site that is just *extremely slow* on certain pages that are very database intensive. Now... I've worked quite a bit with databases before - and this is different. It's ridiculously slow.
I've looked through the long ASP script (it's a calendar listings page, with some more db stuff under the calendar).
There's not really anything else I can do to fix up the code. I've consolodated SQL statements, converted everything to GetRows... closed my objects immediately... etc. I've also added indexes to the db fields in my WHERE clause of SQL.
The page isn't *that* complicated that it should take so long. Sometime it even time-outs.
I've tried so much, and nothing is working.
Could it be that I need a dedicated server? Something I'm missing in the code? (It's really long so I'd prefer not to post it if possible but I might).
MySQL
View Replies
ADVERTISEMENT
I have an asp site that of late is having a very very slow response at the production environment and it is taking 6-7 minutes to do the basic operations that are needed. We have come to know that the performance has deterirated after the recent release.
Going through this thread IIS 6.0 slowing down one of the suggestions listed was to make sure one destroys objects the code creates which I have taken care in all the pages. Actually all the new changes that were to be done involved working with session or local variables and so no com objects were touched.
We are using Windows 2000 server with SP4 at all the environments. Could someone tell me some suggestions on how to identify the problem? This is a problem faced by many at the clients end and this occurs even on server restart. Please let me know if there are any additional details that are needed.
View Replies
View Related
I have an application, which simply consists of an Access database being queried by ASP code in a website, running on a Dell PowerEdge 1650 rack mount server (Pentium III 1.4 GHz) with 1024 MB ram. The server runs Windows 2000 5.00.2195 with Service Pack 4.
The application presents HTML tables to users, based on queries made by the user on the website.
Problem is: recently the construction of these tables has been very slow and the scripts time-out. The script timeout is set to about 3 minutes.
The application has been running for 2 years without any problems, well one. About 6 months ago the same thing was happening. I compacted and repaired the database - did not fix it. However on restarting the server it was back to normal, producing the tables immediately.
Now that the same problem is occuring again, neither a restart or a shutdown-restart fix the problem. The straight HTML part is served immediately, but it is evident that it chokes on the tables.
There are two other applications on the same server written in the same style, but much more simple. They are working fine. Code:
View Replies
View Related
I am to build a site onto an ASP server. Anyone here used Dreamweaver and is it just a simple matter of opening up a new ASP page in Dreamweaver and build the site like you would normally do with a HTML page and it will handle the ASP coding accordingly and you can just simply upload it onto an ASP server and it will work?
The site I am to build is basically just a standard html website, but my friend wants me to build it for an ASP server so he has asked me to make sure it is an asp site so I am presuming with the extension .asp
If I build it as a html site to begin with, will converting it to asp be hard. Could I just export my pages into asp or is there more to it?
Can a Html website be loaded and working on an asp server or host?
Is it possible to have a site mixed both html and asp, eg. the home page is html and when you click on shopping cart on the home page it goes to a hopping cart page thats .asp or do they all have to have the same extension.
View Replies
View Related
I have to pass form data from my site to another organizations site using POST method... how exactly do I do that? Im familiar with how to do it within a single site/domain, and cant use querystring... I dont know where to begin.
View Replies
View Related
Whenever I do a site that is mostly static but with some semi-dynamic
sections, I've struggled to find a good site search solution without
paying for a hosted search service.
I like the FSO-based search engines, but they fail to pick up on some of
the dynamic part.
I was just creating a Google sitemap and it made me wonder: has anyone
created or seen a script that uses the XML Google sitemap to power a
search engine for your own site?
Seems like if you were keeping it updated for Google, why not use it for
your own site?
View Replies
View Related
I need help with a database problem in asp. When the page runs is is timing out.
THere are 18000 records.
Is there something I can do to make it faster or run on the server side before display?
I have set the timeout to 2400 and it is still timing out
View Replies
View Related
I'm trying to surf on a website on winXP, but IIS response is very slow. It doesn't load a lot of images (red x). Besides, it alerts always there's no connection (from each page to the following), asking whether I want to connect. The browser keeps waiting for images then it fails. What can I do?
View Replies
View Related
I developed a page that takes from the database based on a select information and displays that on the screen. My problem is that the display proces is very slow, it takes time to display the results. Code:
View Replies
View Related
in what condition will lead the the ASP page run too slowing.
View Replies
View Related
I've set up a form which sends info to my email address usind CDO 2000 w/ authentication which takes about 10 seconds for the message to get sent.
View Replies
View Related
I'm connecting to an Access table with 100+ rows of data of approx 20 columns wide. I'm using getstring to "Quickly" display it in a table, but it's un-useably slow.
View Replies
View Related
I have a development box running Windows NT Server 4 SP6a with all the
latest hot fixes and patches. Up until a couple of days ago, it was
running IE5.0 without problems. I upgraded to IE6 SP1 and ever since,
whenever I access the default ASP web site, it takes ages for the first
page to appear. After that subsequent pages load fine. Code:
View Replies
View Related
I have migrated to Vista Business and installed IIS 7.0. I moved some
classic ASP pages from my old XP box running IIS to the new box. I've
made no changes to the code, which worked fine on the old machine.
They also run fine on a remote server. On the new machine, the ASP
pages are running extremely slow and timing out with the error "cannot
display the web page." I've verified that I'm making connections to my
Access database (which is fine for my low-volume site) and closing the
connections. I've checked the IIS log and seen no issues. I turned off
my firewall briefly, which didn't help. I watched perfmon and didn't
see that unusual amounts of resources were being used. Code:
View Replies
View Related
I've got a client that has a site that seems to be serving images up slowly.
win2k, xeon, 1gig ram, the box is inhouse. HTML generation and viewing is
blazingly fast. The page size runs around 165k, but is taking 7-10 seconds
to download all the images.
I ran a netstat -an on the box, and see a load of time_wait messages.
The guy who does the networking for them insists that since the images
reside on the same box as the web server, the slowness has nothing to do
with the internal network. hhhmmmm.....
I know there are a hundred reasons for the slowdown, but does the logic of
images on same box not having anything to do with a slowdown make any sense?
View Replies
View Related
I have a basic asp page running that is very slow it has to crunch some info
and when a user hits submit it can take a minute or more for a response. So
what I did was call a second page that should show a gif that is asking them
to be patient.
Unfortunately this never shows (See below). I have tried
other ways as well, but I have been unsuccessful in getting the gif to show.
This has to be simple but I'm not a skilled asp developer so I don;t know
how to do it. Anybody have any ideas?
View Replies
View Related
I just migrated an NT4.0 website (all ASP) to Windows Server 2003 (small business server - deluxe edition) and some pages are very slow to render on client.
Seems to be pages with tables. I can stop the browser by clicking "X" and the table will be partly rendered. The table only has 26 rows and very little content.
Any ideas why this is happening would be appreciated. I have read of others with the same problem but no solutions.
View Replies
View Related
The following code runs in less than one second when used in an ASP page but when used in Session_onStart() in global.asa, the first page in a new session is delayed by more than thirty seconds. The code seems to work - its just slooow. Why is this so and how do I fix it?
Dim cnComDoc
Set cnComDoc = Server.CreateObject("ADODB.Connection")
cnComDoc.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:comdoc.mdb;Persist Security Info=False"
cnComDoc.execute "Insert into SessionInfo
(SessionID,BeginDateTime,IPAddress) values ('" & Session.SessionID & "','" &
FormatDateTime(now(), vbGeneralDate) & "','" &
Request.ServerVariables("REMOTE_ADDR") & "')",,adCmdText +
adExecuteNoRecords
Set cnComDoc = Nothing
View Replies
View Related
I am running a query from MS FoxPro and displaying a table after the query is ompleted. I assume the query of the criteria takes longer than displaying the table...but in this case it's reversed.
After the Query is complete, it takes about 10-20 seconds to display the table, which consists of just information from the database. i.e. customer name, number, vehicle make and model, date it was purchased. Those simple items. Is there a way to make it load/display faster? I am using ASP and MS FoxPro.
View Replies
View Related
Anyone know what might cause my ASP to start running slow? It's been running fine until today. Today when I pull a repost, it takes forever to for the code to create the page.
When I go into the Access database itself and run the individual queries, they run just fine. It only takes a fraction of a second for the data to apprear. When I run the ASP code to see it on the webpage,it takes around 30 seconds!
Anyone got any recommandations on what I need to check? It just doesn't make any sense that all the sudden it runs flat out SLOW.
View Replies
View Related
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="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=MYDATABASE;Data Source=MYCOMPUTER"
View Replies
View Related
I'm reading an XML file in my ASP script which then uses XSL to format the output. However, the script takes a long time to load the script, almost 30 seconds. Code:
set xml = Server.CreateObject("Msxml2.DOMDocument.4.0")
xml.async = false
xml.load(Server.MapPath("XMLTestfile.xml"))
Does anyone know why the webserver will all of the sudden take so long to load the file when it used to work almost instantly?
View Replies
View Related
where I can find information regarding a problem I am having with w2003 ii6 and asp.net. The first page load each morning can run to 1/2hr, which as you can imagine is not exactly making anyone happy. There doesn't appear to be a newsgroup dedicated to asp.net, though I may have been looking in all the wrong places.. so many groups.
I've found some info on the web related to the problem but nothing which discusses what may be going on, nor how to diagnose it.
View Replies
View Related
I have a piece of form processing software that basically saves the form content to an Access database and then sends the data in the form of an email to the specified email address.
I had it running perfectly. Everything worked as it should.
But then strange things started to happen, it would start to slow down in the admin backend when adding new form processors (contains info like required fields, recipents email etc). Code:
View Replies
View Related
I have an application written in ASP. It only uses JavaScript (.js) on
client side. If the browser is accessing the web site through fast
connections, like intranet or broadband, everything is fine; but if the
browser accesses the web site through slow connections like dial-up, IE
continuously crash when you click on buttons or images in the web page. The
crash is always in MSHTML.DLL.
The server is Windows 2000 Advanced Server with SP4 and all updates. The
client machine is Windows 2000 Pro with SP4 and all updates. The browser is
IE6 SP1. The same client machine, if I am visiting the application through
local network, it's ok; if I disabled LAN and use built-in modem to use
dial-up to connect to the web server, the IE always crash. We already
disabled all firewall when testing dial-up. We also tested XP Pro with IE6
SP1 and all the updates, the same result.
View Replies
View Related
I have a stored procedure that is large and accesses the database a lot which slows down the loading of the home page. Is there anyway to load the whole HTML page and then load the stored procedure inside the page?
View Replies
View Related
I have developed an application in asp which is available over intranet. the first page of the site is a login page and allows the users to enter their credentials and login.
The login page is a simple html page. The site works fine , but after quitting if it is left idle for about 30 mins, the next user who tries to login it takes about a minute to process to finally enter the site. after which it again becomes fast.
what can be the reason for the site being slow only when it is accessed after being left idle for some time?
View Replies
View Related
I am using Response.BinaryWrite to display JPEG's to the browser. The
problem is that in IE, one particular JPEG is loading very slow. Normal
JPEG's take a few seconds, but this one sometimes takes up to 30 seconds.
THe weird thing is that if I refresh really quick, the JPEG appears for quick
second, and then the new Response.BinaryWrite kicks in. So, it looks like
the browser has the image, but for some reason it is not finishing loading it
into the browser. Code:
View Replies
View Related
I'm facing problem with file upload over a slow network. Whenever I tried uploading a file that exceeds 3Kb, the browser will freeze for a few minutes before I get the "page over found" error.
I've tried different ASP upload solutions, including 1 from ABCupload, Smartupload and ASPupload from Microsoft, and the result is the same. Does anyone have a solution for this?
View Replies
View Related
website is experiencing extremely slow reaction times. Web pages are taking a long time to load. The site is designed with ASP pages coded with VB Script and run on an MSQL 2000 Server. We are looking for help / tips on how to debug and troubleshoot the problems.
View Replies
View Related
I have built an app that takes some time to load some ASP pages, is there anyway i can display a loading icon or even some interesting pictures and text while this is loading?
View Replies
View Related
I've got a list of variables which have data. Most of them are empty at the time of testing, so it could only be worse if they had data....
Here's the code below. Basically what I want it to do is:
There are a list of variables with data in them (some blank, some not) There is a list of those variables' names that is created into theArray. I want each variable in that array to be run through DocClean in order to convert the JavaScript link. Code:
View Replies
View Related
I am trying to plot the days off employees have taken in the selected month visually using the following code. The code below takes a long time to execute typically about 8-15 secs each time. Code:
View Replies
View Related
