My ASP-access Site Suddenly Very Slow To Respond With Queries
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:
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 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 never ever thought about this, but recently I made a query in access so I can make a customer mailing list based on relational information and it was so easy to make the query and join tables and assign criterea using access. And I haven't tried or thought about this cause in my own small asp projects I've never used a dbase with queries in it, but after seeing how easy it was, it would save a lot of time from manually writting queries in asp.
So, what I'm asking is if I can use a query from an mdb in asp just like I can access tables?
I know that asp can be used to fire off stored procedures within databases, but I was wondering - does a 'query' in Access mean the same thing as stored procedure? If it does, how could I get asp to fire off that procedure when needed?
We have an Access data base with severl tables, queries and forms.We want to put it on the web.Is there a tool that will convert the Access queries and forms to ASP?Sorta like "splitting" the database... but instead of an Access FrontEnd... have an ASP front end?
I have an access DB that has some queries built in to it.
Rather than putting the SQL in to my ASP Code (which I normally do) I was hoping there is some way to run the queries which already exist in the queries portion of the access DB. The queries do require me to input a variable though.
For example, there is one query called qry_FillForm which required me to pass a value called FormID (number)
If I have the value for FormID in my asp code, is there a way I can simply get this query to run? I can always create a
strSQL string and do it that way, I was just wanting to learn if it is even possible simply call the query that is alreay in the DB without having to manually put the SQL into my asp code.
It all seems to work well, but takes a large amount of time for the entire page to load, I guess due to the amount of records that get displayed, or maybe its the repeat region. So, Is there anything I can do in my asp code to speed these things up. Code:
I'd like to transfer al my hard coded sql queries to access stored queries and use them with parameters. Actually, I did not find any strong information how to do that. Please, provide me official information, or give me at least one example of using it(with Select statement or other).
I have a created a cost reporting system which shows a level-breakdown report. There are three levels in the report the lowest level holds the cost items that are entered by the user these records also have an Entry Date. The level above that is a Sum of the lowest level and the top level is the Sum of the second level. I created the solution using three queries in Access. I then use the queries in ASP to generate the report. But now I need to use the Entry Date at the lowest level to re-generate the report with values from the StartDate to the EntryDate (which is entered by the user).
Question is, can I do this using the construction I use, or do I have to pull my queries to the ASP code and include the dynamic EntryDate? How do I solve this?
I have a windows small business server 2003 running IIS 6 to serve asp pages and streaming movie over internet.
Everything was working fine but suddenly the server stop respond to ANY asp request but no problem with html for several hours last night. It serve asp again for awhile but it stop serving again this morning.
I'm working on a system which has been running for a while now, and all of a sudden pages that did work are giving me .
Microsoft VBScript runtime error '800a000d' Type mismatch
errors.
Specifically when trying to compare recordset results to integers. e.g. if (session("opp_cont")=2 and rstCont("cont_ownr")=session("user_id")) then ... These values are coming from SQL server, and the only recent change is that they have been changed from int data type to bigint. I can use strcomp to eveluate them ... but that would mean a lot of code changes.
It was all good when a few days ago, I started getting this error on my Windows 2000 Professional SP4 box when trying to start IIS 5.5.
"The service did not respond to the start or control request in a timely fashion."
I have .NET v1.1 and so I googled for this error. I got a few links, one of which, from the MS KB suggested that I install .NET v1.1 SP 1. I found I already had SP1 for .NET v1.1. However, I downloaded it again and reinstalled it but to no avail.
I am using Windows 2000 server and set number of websites and ftp sites and all seems working just fine. One site had an asp codes like the one below:
const MYSITE="http://www.domain.com"
The strange things is that it suppose to be like the shown above, but the results comes as an error page. I change it to "http://domain.com" it work without error page, but not exactly the results should be, then I added a back slash at the end like "http://domain.com/" and works just fine and got exact results it should be. The site configured in the IIS to work as with and without www. The site works just fine in both www and without in the browser but as I said a certain results for the script that included that code shown above gave that results. Any idea, can you help in guiding me to solve this issue.
I can get to my pages through my private IP, but not my public IP address. This was setup and running fine before under W2k, so it's not a network issue.
I have 2 computers at home, they are both windows 2000 Professional. I linked them, i am able to share and access folders in both. I have created a web site in one computer, i can browse it: http://localhost/ALANLORIMER/default.asp. I failed to browse the same web site from another computer, when i typed http://10.208.28.16/ALANLORIMER/default.asp i was prompted dail-up connection dialog box.
One of my client is requiring that a section of his website to be restraint. It is currently in ASP. The visitor will be attributed an access code. This access code will be alpha numeric and contain 6 digits.
When my user will be entering this digit he will be allowed one hour access to the website. I guess the best way to do this is thru cookies. Any experience on this ?
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.
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.
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?
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?
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:
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.
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:
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'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.
