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
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
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 RelatedI 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 Relatedin what condition will lead the the ASP page run too slowing.
View Replies View RelatedI'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 RelatedI'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 RelatedI 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:
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:
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.
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?
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?
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.
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
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.
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.
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"
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?
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.
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:
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.
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 RelatedI 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?
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:
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?
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 RelatedI 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 RelatedI'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:
On my WinXP machine, with both IE6 and Firefox 1.0, response.redirect and server.transfer take about a minute. But on my WinNT machine with IE5.5, it works instantly. What's going on?
View Replies View RelatedThis is a cross-post from the .NET group since it looks like it may not be
..NET.
New information since the original post is that is the wireless network is
enabled and connected the socket connect time is 4x longer! Disable wireless
and it is back down to just very slow. Code:
I have an Access database with 58 fields in one table. I wrote many
of the field names so that they were descriptive so that others could
figure it out in the future. As an example, one field name is called
MissingPart14990aDescribe.
Should I be worried about the length of the field name? I'm expecting
about 20,000 records a year to be entered into the database. So, five
years from now, which would be about 100,000 records, will the
query.asp for a list of records be slow due to field name size? BTW,
the query.asp would just show a list of the last 3 months worth of
records and only a snapshot of about 6 of the 58 fields.
User clicks a link that displays a customer card and financial stats (has a
lot of database calls). Every 5 times the user clicks the same page/link it
takes about 30 seconds (normal response time is <1 second) to display. Code: