ASP Site Slow Performance
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
ADVERTISEMENT
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
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'm using MSXML2.ServerXMLHTTP to retrieve a webpage. It works, but is unacceptably slow (~20s) when retrieving remote webpages (anything outside our network).Is there any way to improve the performance?
View Replies
View Related
im trying to build some custom shopping cart for a client
what i know about shopping carts is the main idea which is an array stored in the the client's session
also i know that this point (the session) may cause some bad performance and here is my point
any cart contains just the product id and number of items or something like that (some people says data dictionary is good here)
the cart im going to build contains alot od data coz the site client when choose to add some item to his cart must be redirected to some page with a form to add many details about his needs with the product so the session here will carry alot of data ........
so i thought in 2 iedeas
1- array into session
2- some databse table carries all of temporary data with a unique primary key for every session but i need to know the best selution for the best performance
View Replies
View Related
If I a loop that displays a list of records on a page, lets say a list of contacts (lets say 200). The question that I have is does it effect the performance if I add inside the loop the following:
if Arr[0,index]="1" then
.....
end if
View Replies
View Related
Whether it can improve the execution effciency of ASP by centeralizing the often used code into header files and then including these header files in ASP pages?
View Replies
View Related
I have a 500 page ASP program that takes 1-2 seconds to execute. For some strange reason it takes 20-30 seconds before the first lines executes. How can I make this program behave better?
View Replies
View Related
We have several pages that are running very slow, is there any way to
identify which pages are taking the longest to process?
View Replies
View Related
I have a list box with about 500 users in it. I have to populate that on a site. It causes extreme slowness. I am using classic ASP with MS SQL. What is happening is the users are stored as a number (a user_id) and that number is looked up. Then that number is passed through a simple function to turn the number into a name. The names are stored in the DB in first_name, last_name format. The company wants the list box in first_name last_name format so the function is needed. Should I look into database caching, caching the list box somehow, making another table of the user_id's and names in the correct form, or some other option. Once again, I am not using ASP.NET, but classic ASP instead.
View Replies
View Related
I am running the WebService / CurrentConnections performance counter.
It works fine for one site I'm looking at, but not for another.
The one it doesn't work for, the polling vertical red line doesn't even
move.
Is there a setting somewhere that controls whether a web site can be be
'polled' or not?
I am using Windows Server 2003 Standard Edition.
View Replies
View Related
I'm maintaining an ASP Classic file that has HTML withing
Response.Write methods such as
<%
Response.Write "<table><tr><td>"
Response.Write testVariable
Response.Write "</td></tr></table>"
%>
Would their be a performance hit if I were to write this instead?
<table><tr><td><%=testVariable%></td></tr></table>
I need some confirmation.
View Replies
View Related
I have a database with 300,000 records. I have two "DATE" columns and
I need to calcluate the difference and display the number of days in
one of the reports. I was wondering if this calculation of days should
be done on the fly or is it OK to have a "Difference Date"
column[Contains Number of Days] and retrieve the same
Their will be not more than 50 concurrent users accesing it. However,
in the next 6 months the record size is expected to reach 800,000. The
database will be hosted on a shared hosting on the internet
View Replies
View Related
how to display the current connection value on a ASP page. Wanted to know how to read this value into ASP page as opposed to going to performance monitor.
View Replies
View Related
any 1 know of any resource that provides Active Server Page performance on differenct server platforms. I am interested to know what the page/sec, concurrent users (on avarage, this of course depends on other factors) is for Dell PowerEdge servers.
I recall that 40page/sec on 800Mhz server a few years ago was really good. What can I expect from a dual PE1750 3GHz Xeon?
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've been trying to transition an application from an Access db to an Oracle db. I've got the base functionality down, but it's slooow. I'm prety sure that the 8 processor IIS and Oracle servers are more than capable of the low traffic that my code creates.
My question is, what's the most efficient way to do this? I've been and still am doing research on cursors, locktypes, etc... But, I haven't come across something that is similar, so I thought I'd see if anyone here has had the same experience.
Currently my connections/recordsets look like this: Code:
View Replies
View Related
I have a simple data entry form that has text boxes and some drop-down menus per row. My problem is the performance of the page.
I give the user the option of displaying 25, 50 or 100 rows at a time. Each row has 12 text boxes and 4 drop-down menus. The OPTIONS for the drop-down menus are being populated with data from our MS SQL database.
I'm using VIEWS to get the data and place them in recordsets, but how can I increase performance. It's taking way too long for the page to load and if the user clicks submits.. that takes a long time too.
View Replies
View Related
I am writing a page to go into a real large database and pull out the most recent entry and post it to a web page in an ASP document. I think I have the query right, but it is sooooo slow that it isn't a good solution. The code I have to do the query is as follows, but it is soooo slow it doesn't work..
I have another table which is much smaller, where I can find the unique ID values (they only occur once in the other table..) Can I then go to the last record of the larger table and search backwards from there, stopping when I find the each occurance of each ID in the smaller table?
Any ideas how I might go about it? I have searched and searched but haven't been able to come up with something that works yet. Code:
View Replies
View Related
I have a dynamic datagrid on web application, initially it will populate with search result data. in the first or last column will be a edit button to each row, when the user click this edit, it will allow user to see the column of the row shown as dropdownlist, textbook as defined in the datagrid(or TemplateColumn), after the user make their selection on those fields, the value will be valided and save to database.
My question is when come to make choice to populate the DataGrid, I have concern regarding when to load the Grid(further the Dropdownlist for example). do this inner controls populate with data when the user clicked edit, or do they populate with data when the grid was loaded with the search results? Which one would be more efficient in this case? I intend to hold the Population to the DropDownList until user clicked the row, but would wonder if this approach would work or not? how/when to add the value to the DropDownList.Item.collection?
View Replies
View Related
i'm working on a rather big website project (some movie database you can visit here : URL) so i consider myself an experienced developper in ASP / MSSQL2k and recently i've experienced some nasty problems with simple pieces of code that shouldn't have made any problems at all..
what i can add to my intro is that all the pieces of code work, both on the ASP side and the SQL side, the problem is a dramatic performance loss when everything tries to work together..
so, the thing is pretty simple, i have to make some lists of movies and stuff based a few parameters, filter parameters and sorting parameters..
The whole thing is built in a quite huge stored procedure in order to avoid having msqql compile every different query that can come from every combination of parameters, on the fly.. the stored procedure is very basic, a few "if then else" and the queries and it works perfect. Code:
View Replies
View Related
Here i am using windows 2003 with IIS6.0..ASP pages are opening very slow .....Earlier same ASP pages were worked fine in windows NT4.0 with IIS4.0. how to improve ASP pages performance in IIS6.0 rather than IIS4.0.
View Replies
View Related
Two Windows boxes with identical COM objects and databases for comparing and
testing purposes (2000 and 2003) exists as virtual mashines on one big host
server. Network settings for
these VMs are identical (except IP address, of course).
We have on remote client request executing time (getting 3000 rows from DB ~
1.4 Mb amount - measured via Network Monitor) about 3 sec on Windows 2000 VM
and 50 (!) sec for 2003 VM. For local request both time are identical and ~
1.5 sec. Code:
View Replies
View Related
Due to using a combo of OLEDB/ADO/ASP and JavaScript I was having trouble
reading in CSV data so I converted my client's web site to use tab-delimited
instead. Better for me, but client is adamant that their site's recent
timeout problems are since I converted to this tab format?? Code:
View Replies
View Related
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 object is defined as:
<OBJECT ID="docobject" CLASSID="CLSID:9735B64A-792C-8167-5912-18A4B729BBA36"
CODEBASE="DOCCAB.CAB#version=-1,-1,-1,-1" HEIGHT="0" WIDTH="0"></OBJECT>
All machines inc IIS are XP Pro,unfortunately,they are also SP2. I believe the security settings are fine as it allows the download of the cab file without pop up and the execution of the dll. The site is set up globally as a trusted site. Should I move to Intranet site?
View Replies
View Related
I had to make a webpage by "modifying" from other www resources script for an intranet calendar page which contain clickable data for different dates from an Access file.
Adaptation successful (after lots of trial+errors) ... but the loading SPEED is over 7 seconds. IIS 5.0. for IE6.0.
How to find out the limits of the asp page?
--- how to find out how many simultaneous hits can it sustains?
--- how to speed it up?
I have read the MS 25+ tips to improve performance & style article but I cannot do much from there and it is not easy to add the response dot flush as the table of the calendar is generated from loops within loops within loops (many if then else).
View Replies
View Related
The default ASP generates the HTML response including several IFRAMES. It takes a long time to load this page. I believe a lot of it is round trips to load the IFRAMES. Couldn't include files be used to increase this performance, so everything is done in the initial call instead of multiple round trips?
View Replies
View Related
I have a big application, about 800 asp pages.
Since we made a few changes, the processor usage on all 4 servers is constantly at 100%. iisreset cures this for a while.
Process Explorer reports that the main hog is the instance of dllhost.exe that manages the application in IIS to which we have made changes to common include files.
It is also racking up Page Faults of 3000 per second (not web page faults, memory faults).
How can I find out which piece of code is causing the processor to freak out so badly? Any tools out there?
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
