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:
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 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 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?
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
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).
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
What is this:Code:
Â
and why has it suddenly started appearing in emails from an asp page using CDONTS to send an email?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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 ?
View Replies
View Related
I can't get my browser to find my testing directory on my IIS enabled machine???
My "index.asp" page calls the following header file "header.html" and I get the following error...
Error Type:
Active Server Pages, ASP 0126 (0x80004005)
The include file 'includes/header.html' was not found.
My code that calls the include file is...
<!--#include virtual="includes/header.html"-->
Am I putting something in an incorrect directory?
I've checked my path over and over and it's not working. It worked EARLIER!!!
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
