473,320 Members | 1,910 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

elminate the hanging processes

My webhosting company cut off my website the other day
because i had "too many hanging processes"

What does this mean and what can i do to prevent this from
happening. They gave me the following readout...

X 13:02:32.954 24 844 933 Preproc headers
24.101.225.120 111433 ns
0 un GET
http://www.sny.ca/investing/institut...ctdetails.asp?
InvestmentProductID=12
X 13:02:40.626 24 837 261 Authentication
24.101.225.120 111454 ns 0
un GET
http://www.sny.ca/investing/search.asp?
t=30&MinInvestment=1&RSPEligibility=2&cmdRefresh=R efresh
X 13:08:27.287 24 490 599 Authentication
24.101.225.120 112977 ns 0
un GET
ResellersLive (4:52:21 PM):
http://www.sny.ca/investing/search.asp?
t=30&MinInvestment=1&RSPEligibility=2&cmdRefresh=R efresh
X 13:09:19.327 24 438 560 Authentication
24.101.225.120 113243 ns 0
un GET
http://www.sny.ca/investing/search.asp?
t=0&MinInvestment=1&RSPEligibility=2&cmdRefresh=Re fresh
X 13:48:50.103 22 067 783 Authentication
24.101.225.120 126007 ns 0
un GET
http://www.sny.ca/investing/search.asp?
t=0&MinInvestment=0&RSPEligibility=2&cmdRefresh=Re fresh
X 13:49:06.738 22 051 149 Preproc headers
24.101.225.120 126128 ns

ResellersLive (4:52:23 PM): 0 un GET
http://www.sny.ca/X 19:50:43.529 354 357 Preproc
headers 24.101.225.120 232810 ns 0un
GEThttp://www.sny.ca/investing/institution_productdetails.a
sp?InvestmentProductID=5X 19:55:04.647 93 240 Preproc
headers 24.101.225.120 233802 ns 0un
GEThttp://www.sny.ca/investing/institution_productdetails.a
sp?InvestmentProductID=5X 19:55:11.318 86 569
Authentication 24.101.225.120 233832 ns 0
unGEThttp://www.sny.ca/investing/institution_productdetails
..asp?InvestmentProductID=12X 19:55:54.075 43 812
Authentication 24.101.225.120 233958 ns 0
unGEThttp://www.sny.ca/investing/search.asp?
t=0&MinInvestment=0&RSPEligibility=0&OrderByRSP.x= 31&OrderB
yRSP.y=7

I haven't a clue what all that means. My website used two
databases that i connected through without and ODBC
connection (i gave ADO the real path of the database file
on every open)

The typial website had about 5-10 include files and i
always closed my rs at the end of every asp file.

Throughout the site i use the CreateObject method (used on
all of the above listed files). I do not set them to null
at the end of hte asp file - should i?

Anything else?

I know in VB i can use the Unload command to unload the
form, and i can use hte END command to end the program
(albiet a crude way of doing so), is there anything like
this in asp?

please help!

Siomn
we*******@sny.ca
Jul 19 '05 #1
7 2151
joe
Are you doing anything to help limit the impact of abandoned processes where
the object hasn't been unloaded through your code?

Not sure if that would cause your problem but it's worth a thought.

ASP.Net performs a cleanup for such things that I don't believe ASP does.

"Simon" <we*******@sny.ca> wrote in message
news:05****************************@phx.gbl...
My webhosting company cut off my website the other day
because i had "too many hanging processes"

What does this mean and what can i do to prevent this from
happening. They gave me the following readout...

X 13:02:32.954 24 844 933 Preproc headers
24.101.225.120 111433 ns
0 un GET
http://www.sny.ca/investing/institut...ctdetails.asp?
InvestmentProductID=12
X 13:02:40.626 24 837 261 Authentication
24.101.225.120 111454 ns 0
un GET
http://www.sny.ca/investing/search.asp?
t=30&MinInvestment=1&RSPEligibility=2&cmdRefresh=R efresh
X 13:08:27.287 24 490 599 Authentication
24.101.225.120 112977 ns 0
un GET
ResellersLive (4:52:21 PM):
http://www.sny.ca/investing/search.asp?
t=30&MinInvestment=1&RSPEligibility=2&cmdRefresh=R efresh
X 13:09:19.327 24 438 560 Authentication
24.101.225.120 113243 ns 0
un GET
http://www.sny.ca/investing/search.asp?
t=0&MinInvestment=1&RSPEligibility=2&cmdRefresh=Re fresh
X 13:48:50.103 22 067 783 Authentication
24.101.225.120 126007 ns 0
un GET
http://www.sny.ca/investing/search.asp?
t=0&MinInvestment=0&RSPEligibility=2&cmdRefresh=Re fresh
X 13:49:06.738 22 051 149 Preproc headers
24.101.225.120 126128 ns

ResellersLive (4:52:23 PM): 0 un GET
http://www.sny.ca/X 19:50:43.529 354 357 Preproc
headers 24.101.225.120 232810 ns 0un
GEThttp://www.sny.ca/investing/institution_productdetails.a
sp?InvestmentProductID=5X 19:55:04.647 93 240 Preproc
headers 24.101.225.120 233802 ns 0un
GEThttp://www.sny.ca/investing/institution_productdetails.a
sp?InvestmentProductID=5X 19:55:11.318 86 569
Authentication 24.101.225.120 233832 ns 0
unGEThttp://www.sny.ca/investing/institution_productdetails
.asp?InvestmentProductID=12X 19:55:54.075 43 812
Authentication 24.101.225.120 233958 ns 0
unGEThttp://www.sny.ca/investing/search.asp?
t=0&MinInvestment=0&RSPEligibility=0&OrderByRSP.x= 31&OrderB
yRSP.y=7

I haven't a clue what all that means. My website used two
databases that i connected through without and ODBC
connection (i gave ADO the real path of the database file
on every open)

The typial website had about 5-10 include files and i
always closed my rs at the end of every asp file.

Throughout the site i use the CreateObject method (used on
all of the above listed files). I do not set them to null
at the end of hte asp file - should i?

Anything else?

I know in VB i can use the Unload command to unload the
form, and i can use hte END command to end the program
(albiet a crude way of doing so), is there anything like
this in asp?

please help!

Siomn
we*******@sny.ca

Jul 19 '05 #2
joe
One other thing ....are you using a detached dataset when hitting your
database? Are you using Views vs the actual tables? Is your host
complaining about Database processes or your application processes?

"joe" <contact_by_Newsgroup_only.please> wrote in message
news:OY**************@TK2MSFTNGP10.phx.gbl...
Are you doing anything to help limit the impact of abandoned processes where the object hasn't been unloaded through your code?

Not sure if that would cause your problem but it's worth a thought.

ASP.Net performs a cleanup for such things that I don't believe ASP does.

"Simon" <we*******@sny.ca> wrote in message
news:05****************************@phx.gbl...
My webhosting company cut off my website the other day
because i had "too many hanging processes"

What does this mean and what can i do to prevent this from
happening. They gave me the following readout...

X 13:02:32.954 24 844 933 Preproc headers
24.101.225.120 111433 ns
0 un GET
http://www.sny.ca/investing/institut...ctdetails.asp?
InvestmentProductID=12
X 13:02:40.626 24 837 261 Authentication
24.101.225.120 111454 ns 0
un GET
http://www.sny.ca/investing/search.asp?
t=30&MinInvestment=1&RSPEligibility=2&cmdRefresh=R efresh
X 13:08:27.287 24 490 599 Authentication
24.101.225.120 112977 ns 0
un GET
ResellersLive (4:52:21 PM):
http://www.sny.ca/investing/search.asp?
t=30&MinInvestment=1&RSPEligibility=2&cmdRefresh=R efresh
X 13:09:19.327 24 438 560 Authentication
24.101.225.120 113243 ns 0
un GET
http://www.sny.ca/investing/search.asp?
t=0&MinInvestment=1&RSPEligibility=2&cmdRefresh=Re fresh
X 13:48:50.103 22 067 783 Authentication
24.101.225.120 126007 ns 0
un GET
http://www.sny.ca/investing/search.asp?
t=0&MinInvestment=0&RSPEligibility=2&cmdRefresh=Re fresh
X 13:49:06.738 22 051 149 Preproc headers
24.101.225.120 126128 ns

ResellersLive (4:52:23 PM): 0 un GET
http://www.sny.ca/X 19:50:43.529 354 357 Preproc
headers 24.101.225.120 232810 ns 0un
GEThttp://www.sny.ca/investing/institution_productdetails.a
sp?InvestmentProductID=5X 19:55:04.647 93 240 Preproc
headers 24.101.225.120 233802 ns 0un
GEThttp://www.sny.ca/investing/institution_productdetails.a
sp?InvestmentProductID=5X 19:55:11.318 86 569
Authentication 24.101.225.120 233832 ns 0
unGEThttp://www.sny.ca/investing/institution_productdetails
.asp?InvestmentProductID=12X 19:55:54.075 43 812
Authentication 24.101.225.120 233958 ns 0
unGEThttp://www.sny.ca/investing/search.asp?
t=0&MinInvestment=0&RSPEligibility=0&OrderByRSP.x= 31&OrderB
yRSP.y=7

I haven't a clue what all that means. My website used two
databases that i connected through without and ODBC
connection (i gave ADO the real path of the database file
on every open)

The typial website had about 5-10 include files and i
always closed my rs at the end of every asp file.

Throughout the site i use the CreateObject method (used on
all of the above listed files). I do not set them to null
at the end of hte asp file - should i?

Anything else?

I know in VB i can use the Unload command to unload the
form, and i can use hte END command to end the program
(albiet a crude way of doing so), is there anything like
this in asp?

please help!

Siomn
we*******@sny.ca


Jul 19 '05 #3
If I understand you correctly, i think your asking if i do
anything to close the recordset or null the object
variables if the user hits the Stop button before the page
loads. If I'm right, the answer is no - how do i go about
doing that?

Simon
we*******@sny.ca
-----Original Message-----
Are you doing anything to help limit the impact of abandoned processes wherethe object hasn't been unloaded through your code?

Not sure if that would cause your problem but it's worth a thought.
ASP.Net performs a cleanup for such things that I don't believe ASP does.


"Simon" <we*******@sny.ca> wrote in message
news:05****************************@phx.gbl...
My webhosting company cut off my website the other day
because i had "too many hanging processes"

What does this mean and what can i do to prevent this from happening. They gave me the following readout...

X 13:02:32.954 24 844 933 Preproc headers
24.101.225.120 111433 ns
0 un GET
http://www.sny.ca/investing/institut...ctdetails.asp? InvestmentProductID=12
X 13:02:40.626 24 837 261 Authentication
24.101.225.120 111454 ns 0
un GET
http://www.sny.ca/investing/search.asp?
t=30&MinInvestment=1&RSPEligibility=2&cmdRefresh=R efresh
X 13:08:27.287 24 490 599 Authentication
24.101.225.120 112977 ns 0
un GET
ResellersLive (4:52:21 PM):
http://www.sny.ca/investing/search.asp?
t=30&MinInvestment=1&RSPEligibility=2&cmdRefresh=R efresh
X 13:09:19.327 24 438 560 Authentication
24.101.225.120 113243 ns 0
un GET
http://www.sny.ca/investing/search.asp?
t=0&MinInvestment=1&RSPEligibility=2&cmdRefresh=Re fresh
X 13:48:50.103 22 067 783 Authentication
24.101.225.120 126007 ns 0
un GET
http://www.sny.ca/investing/search.asp?
t=0&MinInvestment=0&RSPEligibility=2&cmdRefresh=Re fresh
X 13:49:06.738 22 051 149 Preproc headers
24.101.225.120 126128 ns

ResellersLive (4:52:23 PM): 0 un GET
http://www.sny.ca/X 19:50:43.529 354 357 Preproc
headers 24.101.225.120 232810 ns 0un
GEThttp://www.sny.ca/investing/institution_productdetails.a sp?InvestmentProductID=5X 19:55:04.647 93 240 Preproc headers 24.101.225.120 233802 ns 0un
GEThttp://www.sny.ca/investing/institution_productdetails.a sp?InvestmentProductID=5X 19:55:11.318 86 569
Authentication 24.101.225.120 233832 ns 0
unGEThttp://www.sny.ca/investing/institution_productdetails .asp?InvestmentProductID=12X 19:55:54.075 43 812
Authentication 24.101.225.120 233958 ns 0
unGEThttp://www.sny.ca/investing/search.asp?
t=0&MinInvestment=0&RSPEligibility=0&OrderByRSP.x= 31&OrderB yRSP.y=7

I haven't a clue what all that means. My website used two databases that i connected through without and ODBC
connection (i gave ADO the real path of the database file on every open)

The typial website had about 5-10 include files and i
always closed my rs at the end of every asp file.

Throughout the site i use the CreateObject method (used on all of the above listed files). I do not set them to null at the end of hte asp file - should i?

Anything else?

I know in VB i can use the Unload command to unload the
form, and i can use hte END command to end the program
(albiet a crude way of doing so), is there anything like
this in asp?

please help!

Siomn
we*******@sny.ca

.

Jul 19 '05 #4
I'd love to upgrade, but i cant afford VStudio.NET so i'm
just trying to make do for now.

As for my host they're not saying. They're only response
is "everything we found is explained up there (in the IIS
Trace readout)" and "you need to ask your programmer that".

I can easily quote them because their only means of "real-
time" tech support is through IM. - You get what you pay
for.

As for the database, i dont create a database object... i
open the recordset as follows....

<html>
<body>
<%
Option Explicit

Dim sConnectionString
sConnectionSring = "Driver={Microsoft Access Driver
(*.mdb)};DBQ=" & Server.MapPath("../cgi-bin/sny.mdb") & ";"

Dim rs
Set rs = Server.CreateObject("ADODB.recordset")
rs.Open "Institutions",sConnectionSring
rs.MoveFirst
Response.Write rs("InstitutionName")
rs.Close

%>
</body>
</html>
Well okay, maybe my webpages arn't that dull, but besides
the standard html, thats about it. Anything i can do to
keep "this is unacceptable" website from crashing?

-----Original Message-----
Not only that but the connection to the database should be closed while theuser is working with the dataset.

It sounds like your application is an ideal candidate for upgrade toASP.Net. vs just ASP.


"Simon" <we*******@sny.ca> wrote in message
news:02****************************@phx.gbl...
If I understand you correctly, i think your asking if i do
anything to close the recordset or null the object
variables if the user hits the Stop button before the page loads. If I'm right, the answer is no - how do i go about doing that?

Simon
we*******@sny.ca
>-----Original Message-----
>Are you doing anything to help limit the impact of

abandoned processes where
>the object hasn't been unloaded through your code?
>
>Not sure if that would cause your problem but it's worth
a thought.
>
>ASP.Net performs a cleanup for such things that I don't

believe ASP does.
>
>
>
>
>
>"Simon" <we*******@sny.ca> wrote in message
>news:05****************************@phx.gbl...
>> My webhosting company cut off my website the other
day >> because i had "too many hanging processes"
>>
>> What does this mean and what can i do to prevent this

from
>> happening. They gave me the following readout...
>>
>> X 13:02:32.954 24 844 933 Preproc headers
>> 24.101.225.120 111433 ns
>> 0 un GET
>>

http://www.sny.ca/investing/institut...ctdetails.asp?
>> InvestmentProductID=12
>> X 13:02:40.626 24 837 261 Authentication
>> 24.101.225.120 111454 ns 0
>> un GET
>> http://www.sny.ca/investing/search.asp?
>> t=30&MinInvestment=1&RSPEligibility=2&cmdRefresh=R efresh >> X 13:08:27.287 24 490 599 Authentication
>> 24.101.225.120 112977 ns 0
>> un GET
>> ResellersLive (4:52:21 PM):
>> http://www.sny.ca/investing/search.asp?
>> t=30&MinInvestment=1&RSPEligibility=2&cmdRefresh=R efresh >> X 13:09:19.327 24 438 560 Authentication
>> 24.101.225.120 113243 ns 0
>> un GET
>> http://www.sny.ca/investing/search.asp?
>> t=0&MinInvestment=1&RSPEligibility=2&cmdRefresh=Re fresh >> X 13:48:50.103 22 067 783 Authentication
>> 24.101.225.120 126007 ns 0
>> un GET
>> http://www.sny.ca/investing/search.asp?
>> t=0&MinInvestment=0&RSPEligibility=2&cmdRefresh=Re fresh >> X 13:49:06.738 22 051 149 Preproc headers
>> 24.101.225.120 126128 ns
>>
>> ResellersLive (4:52:23 PM): 0 un GET
>> http://www.sny.ca/X 19:50:43.529 354 357 Preproc
>> headers 24.101.225.120 232810 ns 0un
>>

GEThttp://www.sny.ca/investing/institution_productdetails.a
>> sp?InvestmentProductID=5X 19:55:04.647 93 240

Preproc
>> headers 24.101.225.120 233802 ns 0un
>>

GEThttp://www.sny.ca/investing/institution_productdetails.a
>> sp?InvestmentProductID=5X 19:55:11.318 86 569
>> Authentication 24.101.225.120 233832 ns 0
>>

unGEThttp://www.sny.ca/investing/institution_productdetails
>> .asp?InvestmentProductID=12X 19:55:54.075 43 812
>> Authentication 24.101.225.120 233958 ns 0
>> unGEThttp://www.sny.ca/investing/search.asp?
>>

t=0&MinInvestment=0&RSPEligibility=0&OrderByRSP.x= 31&OrderB
>> yRSP.y=7
>>
>> I haven't a clue what all that means. My website used

two
>> databases that i connected through without and ODBC
>> connection (i gave ADO the real path of the database

file
>> on every open)
>>
>> The typial website had about 5-10 include files and i
>> always closed my rs at the end of every asp file.
>>
>> Throughout the site i use the CreateObject method (used on
>> all of the above listed files). I do not set them to

null
>> at the end of hte asp file - should i?
>>
>> Anything else?
>>
>> I know in VB i can use the Unload command to unload

the >> form, and i can use hte END command to end the program >> (albiet a crude way of doing so), is there anything like >> this in asp?
>>
>> please help!
>>
>> Siomn
>> we*******@sny.ca
>
>
>.
>

.

Jul 19 '05 #5
Don't forget
Set rs = nothing
This is vital.

Bob Barrows
Simon wrote:
I'd love to upgrade, but i cant afford VStudio.NET so i'm
just trying to make do for now.

As for my host they're not saying. They're only response
is "everything we found is explained up there (in the IIS
Trace readout)" and "you need to ask your programmer that".

I can easily quote them because their only means of "real-
time" tech support is through IM. - You get what you pay
for.

As for the database, i dont create a database object... i
open the recordset as follows....

<html>
<body>
<%
Option Explicit

Dim sConnectionString
sConnectionSring = "Driver={Microsoft Access Driver
(*.mdb)};DBQ=" & Server.MapPath("../cgi-bin/sny.mdb") & ";"

Dim rs
Set rs = Server.CreateObject("ADODB.recordset")
rs.Open "Institutions",sConnectionSring
rs.MoveFirst
Response.Write rs("InstitutionName")
rs.Close

%>
</body>
</html>
Well okay, maybe my webpages arn't that dull, but besides
the standard html, thats about it. Anything i can do to
keep "this is unacceptable" website from crashing?

-----Original Message-----
Not only that but the connection to the database should be closed
while the user is working with the dataset.

It sounds like your application is an ideal candidate for upgrade to
ASP.Net. vs just ASP.


"Simon" <we*******@sny.ca> wrote in message
news:02****************************@phx.gbl...
If I understand you correctly, i think your asking if i do
anything to close the recordset or null the object
variables if the user hits the Stop button before the page
loads. If I'm right, the answer is no - how do i go about
doing that?

Simon
we*******@sny.ca

-----Original Message-----
Are you doing anything to help limit the impact of abandoned
processes where the object hasn't been unloaded through your code?

Not sure if that would cause your problem but it's worth a thought.

ASP.Net performs a cleanup for such things that I don't believe
ASP does.

"Simon" <we*******@sny.ca> wrote in message
news:05****************************@phx.gbl...
> My webhosting company cut off my website the other day
> because i had "too many hanging processes"
>
> What does this mean and what can i do to prevent this from
> happening. They gave me the following readout...
>
> X 13:02:32.954 24 844 933 Preproc headers
> 24.101.225.120 111433 ns
> 0 un GET
>
http://www.sny.ca/investing/institut...ctdetails.asp?> InvestmentProductID=12
> X 13:02:40.626 24 837 261 Authentication
> 24.101.225.120 111454 ns 0
> un GET
> http://www.sny.ca/investing/search.asp?
> t=30&MinInvestment=1&RSPEligibility=2&cmdRefresh=R efresh> X 13:08:27.287 24 490 599 Authentication
> 24.101.225.120 112977 ns 0
> un GET
> ResellersLive (4:52:21 PM):
> http://www.sny.ca/investing/search.asp?
> t=30&MinInvestment=1&RSPEligibility=2&cmdRefresh=R efresh> X 13:09:19.327 24 438 560 Authentication
> 24.101.225.120 113243 ns 0
> un GET
> http://www.sny.ca/investing/search.asp?
> t=0&MinInvestment=1&RSPEligibility=2&cmdRefresh=Re fresh> X 13:48:50.103 22 067 783 Authentication
> 24.101.225.120 126007 ns 0
> un GET
> http://www.sny.ca/investing/search.asp?
> t=0&MinInvestment=0&RSPEligibility=2&cmdRefresh=Re fresh> X 13:49:06.738 22 051 149 Preproc headers
> 24.101.225.120 126128 ns
>
> ResellersLive (4:52:23 PM): 0 un GET
> http://www.sny.ca/X 19:50:43.529 354 357 Preproc
> headers 24.101.225.120 232810 ns 0un
>
GEThttp://www.sny.ca/investing/institution_productdetails.a> sp?InvestmentProductID=5X 19:55:04.647 93 240 Preproc
> headers 24.101.225.120 233802 ns 0un
>
GEThttp://www.sny.ca/investing/institution_productdetails.a> sp?InvestmentProductID=5X 19:55:11.318 86 569
> Authentication 24.101.225.120 233832 ns 0
>
unGEThttp://www.sny.ca/investing/institution_productdetails> .asp?InvestmentProductID=12X 19:55:54.075 43 812
> Authentication 24.101.225.120 233958 ns 0
> unGEThttp://www.sny.ca/investing/search.asp?
>
t=0&MinInvestment=0&RSPEligibility=0&OrderByRSP.x= 31&OrderB> yRSP.y=7
>
> I haven't a clue what all that means. My website used two
> databases that i connected through without and ODBC
> connection (i gave ADO the real path of the database file
> on every open)
>
> The typial website had about 5-10 include files and i
> always closed my rs at the end of every asp file.
>
> Throughout the site i use the CreateObject method (used on
> all of the above listed files). I do not set them to null
> at the end of hte asp file - should i?
>
> Anything else?
>
> I know in VB i can use the Unload command to unload the
> form, and i can use hte END command to end the program
> (albiet a crude way of doing so), is there anything like
> this in asp?
>
> please help!
>
> Siomn
> we*******@sny.ca
.

.


Jul 19 '05 #6
Kewl, I'll give it a try. Hopefully i wont get cut off
this time. Thanks Joe and Bob for all your help!

Best wishes,

Simon
-----Original Message-----
It's been reported as being a leading cause of memory leaks which can leadto "hung" servers.

Bob

Simon wrote:
Ahh.. okay so i doo need to clear my object variables...
its all falling into place.... :-)

So by me not doing this, would this create those hung
processes?
-----Original Message-----
Don't forget
Set rs = nothing
This is vital.

Bob Barrows
Simon wrote:
I'd love to upgrade, but i cant afford VStudio.NET so i'm just trying to make do for now.

As for my host they're not saying. They're only response is "everything we found is explained up there (in the IIS Trace readout)" and "you need to ask your programmer that".
I can easily quote them because their only means

of "real-
time" tech support is through IM. - You get what you pay for.

As for the database, i dont create a database object... i open the recordset as follows....

<html>
<body>
<%
Option Explicit

Dim sConnectionString
sConnectionSring = "Driver={Microsoft Access Driver
(*.mdb)};DBQ=" & Server.MapPath("../cgi-bin/sny.mdb")

& ";"

Dim rs
Set rs = Server.CreateObject("ADODB.recordset")
rs.Open "Institutions",sConnectionSring
rs.MoveFirst
Response.Write rs("InstitutionName")
rs.Close

%>
</body>
</html>
Well okay, maybe my webpages arn't that dull, but besides the standard html, thats about it. Anything i can do to keep "this is unacceptable" website from crashing?
> -----Original Message-----
> Not only that but the connection to the database should be closed> while the user is working with the dataset.
>
> It sounds like your application is an ideal candidate for upgrade> to ASP.Net. vs just ASP.
>
>
>
>
>
>
> "Simon" <we*******@sny.ca> wrote in message
> news:02****************************@phx.gbl...
>> If I understand you correctly, i think your asking if i do>> anything to close the recordset or null the object
>> variables if the user hits the Stop button before the page>> loads. If I'm right, the answer is no - how do i go about>> doing that?
>>
>> Simon
>> we*******@sny.ca
>>
>>> -----Original Message-----
>>> Are you doing anything to help limit the impact of abandoned>>> processes where the object hasn't been unloaded through your>>> code?
>>>
>>> Not sure if that would cause your problem but it's worth a>>> thought.
>>>
>>> ASP.Net performs a cleanup for such things that I don't believe>>> ASP does.
>>>
>>>
>>>
>>>
>>>
>>> "Simon" <we*******@sny.ca> wrote in message
>>> news:05****************************@phx.gbl...
>>>> My webhosting company cut off my website the other day>>>> because i had "too many hanging processes"
>>>>
>>>> What does this mean and what can i do to prevent this from>>>> happening. They gave me the following readout...
>>>>
>>>> X 13:02:32.954 24 844 933 Preproc headers
>>>> 24.101.225.120 111433 ns
>>>> 0 un GET
>>>>
>>

http://www.sny.ca/investing/institut...ctdetails.asp?
>>>> InvestmentProductID=12
>>>> X 13:02:40.626 24 837 261 Authentication
>>>> 24.101.225.120 111454 ns 0
>>>> un GET
>>>> http://www.sny.ca/investing/search.asp?
>>>>
t=30&MinInvestment=1&RSPEligibility=2&cmdRefresh=R efresh>>>> X 13:08:27.287 24 490 599 Authentication
>>>> 24.101.225.120 112977 ns 0
>>>> un GET
>>>> ResellersLive (4:52:21 PM):
>>>> http://www.sny.ca/investing/search.asp?
>>>>
t=30&MinInvestment=1&RSPEligibility=2&cmdRefresh=R efresh>>>> X 13:09:19.327 24 438 560 Authentication
>>>> 24.101.225.120 113243 ns 0
>>>> un GET
>>>> http://www.sny.ca/investing/search.asp?
>>>>
t=0&MinInvestment=1&RSPEligibility=2&cmdRefresh=Re fresh>>>> X 13:48:50.103 22 067 783 Authentication
>>>> 24.101.225.120 126007 ns 0
>>>> un GET
>>>> http://www.sny.ca/investing/search.asp?
>>>>
t=0&MinInvestment=0&RSPEligibility=2&cmdRefresh=Re fresh>>>> X 13:49:06.738 22 051 149 Preproc headers
>>>> 24.101.225.120 126128 ns
>>>>
>>>> ResellersLive (4:52:23 PM): 0 un GET
>>>> http://www.sny.ca/X 19:50:43.529 354 357 Preproc>>>> headers 24.101.225.120 232810 ns 0un
>>>>
>>

GEThttp://www.sny.ca/investing/institution_productdetails.a
>>>> sp?InvestmentProductID=5X 19:55:04.647 93 240 Preproc>>>> headers 24.101.225.120 233802 ns 0un
>>>>
>>

GEThttp://www.sny.ca/investing/institution_productdetails.a
>>>> sp?InvestmentProductID=5X 19:55:11.318 86 569
>>>> Authentication 24.101.225.120 233832 ns 0
>>>>
>>

unGEThttp://www.sny.ca/investing/institution_productdetails
>>>> .asp?InvestmentProductID=12X 19:55:54.075 43 812
>>>> Authentication 24.101.225.120 233958 ns 0
>>>> unGEThttp://www.sny.ca/investing/search.asp?
>>>>
>>

t=0&MinInvestment=0&RSPEligibility=0&OrderByRSP.x= 31&OrderB
>>>> yRSP.y=7
>>>>
>>>> I haven't a clue what all that means. My website used two>>>> databases that i connected through without and ODBC>>>> connection (i gave ADO the real path of the database file>>>> on every open)
>>>>
>>>> The typial website had about 5-10 include files and i>>>> always closed my rs at the end of every asp file.
>>>>
>>>> Throughout the site i use the CreateObject method (used on>>>> all of the above listed files). I do not set them to null>>>> at the end of hte asp file - should i?
>>>>
>>>> Anything else?
>>>>
>>>> I know in VB i can use the Unload command to unload the>>>> form, and i can use hte END command to end the program>>>> (albiet a crude way of doing so), is there anything like>>>> this in asp?
>>>>
>>>> please help!
>>>>
>>>> Siomn
>>>> we*******@sny.ca
>>>
>>>
>>> .
>>>
>
>
> .

.


.

Jul 19 '05 #7
> I'd love to upgrade, but i cant afford VStudio.NET so i'm
just trying to make do for now.


Surely you can afford notepad or web matrix (http://www.asp.net).
Jul 19 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Harlan Messinger | last post by:
A publication style guide indicates that for a table heading like the following, Table 3. Wheat and rye harvest in European countries in years that end in 3 or 7 or when a new prime minister...
25
by: Shannon Jacobs | last post by:
Maybe there is a simple trick here, and I'm not spotting it... Is there a guru of CSS hanging around here who can help out? The page in question has a multi-column table with a list of links in...
2
by: Jim | last post by:
We are experiencing a problem with component services in .Net and IIS. We use component services to handle transactions against SQL Server. At some point of usage, IIS will hang up and the lowest...
5
by: David C. Allen | last post by:
I have a vb.net app that is controling excel 2000 thru the com interop interface. I have referenced the excel 9.0 library and have cut down the code in the problem subroutine to this: Dim...
3
by: Steve Crawford | last post by:
When I run: vacuumdb --full --all --analyze --quiet on my database cluster it will complete in < 2 minutes (this cluster is a few million total rows and ~2GB). After testing, I set this up as...
1
by: Marcel Groner | last post by:
I have a problem with postgresql runnung on smp kernel. setup: master: ------- - Pentium 4 (hyperthreading) - 2 GB Memory - os: fedora core 1 - kernel: 2.4.22-1.2188.nptlsmp
14
by: Rochester | last post by:
Hi, I just found out that the general open file mechanism doesn't work for named pipes (fifo). Say I wrote something like this and it simply hangs python: #!/usr/bin/python import os
0
by: Jorre Meijrink | last post by:
Dear reader, We have two Win2003 webfarms each consisting of 5 servers. Which we call cluster1 and cluster2. Cluster2 is the bussiest of these two and periodicaly (varies from 2 times per day to...
1
by: =?iso-8859-1?q?Jean-Fran=E7ois_Michaud?= | last post by:
Hello guys, I was wondering if anybody here had implemented a solution where Tables are aligned according to what the hanging indent tells us when there is a potential for the table overflowing...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.