there are two places on the web site where on average 350 items are added or
updated.
When any of these two actions occur, for 3 - 5+ seconds, the CPU usage on
the server is pegged at 100%, and the database is locked for that entire
period. Then, if nobody else is using the database or ordering platform, it
will continue as normal. Code:
why this isn't working?
cid, uid, u, d, and s are numbers
sd, ed are dates
c is text
myC = "INSERT INTO tbl_requests(req_client, req_user, req_unit_id,
req_cat_id, req_shift_id, req_start, req_end, req_sp_req,
req_submitted, req_status) VALUES" & "(" & cid & ", " & uid & ", " &
u & ", " & d & ", " & s & ", #" & sd & "#, #" & ed & "#, '" & c &
"', #" & now() & "#, " & 1 & ")"
conn.execute myc
I am experiencing a problem with our ASP service. OS: windows 2000 server, service pack 4. IIS 5.0 working with Oracle 9i. Our ASP service collapses and restarts once in a while (short while... practically every day). The symptoms are that first we see some of the ASP having the error: |0|ASP_0100_:_8007000e|Out_of_memory 500 0 0 while others work fine.
During that time the virtual memory usage goes up and up and the processiort works at 100%, After about 15 seconds the memory usage goes over the top and the ASP service restarts.
When restarting the ASP's return: Out-of-process+ISAPI+extension+request+failed. 500 1726 4203 (which is probalbly because the service is down). After the restart everythign is fine again -but they become more and more freaquent, and having between 50-300 concurrent users that get kicked out this becomes a real problem.
My site has just started crashing the server. They said that every time my site ran it crashed the server requiring it to be reset. Because this is disrupting other accounts mine has been suspended. Below is the last log before the site crashed.
2003-10-06 09:27:30 64.62.156.55 GET /Logon/join.asp
|-|ASP_0113|Script_timed_out 80 - 81.136.229.48
Mozilla/5.0+(Windows;+U;+Windows+NT+5.1;+en-US;+rv:1.5a)+Gecko/20030728+Mozi
lla+Firebird/0.6.1 http://64.62.156.55/ 500 0 0 .
I am trying to update an excel sheet with asp over a webpage. Now i am able to view the contents of the xls file so my connenction is ok. However if i try to update a cell in the xls the browser just stops responding. I already tried switching of script blocking from norton and also switched of my firewall for a sec. Code:
View Replies View Related