elminate the hanging processes

**joe** · Jul 19 '05, 05:35 AM

Re: elminate the hanging processes

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" <webmaster@sny. ca> wrote in message
news:059f01c347 2b$ca5093b0$a10 1280a@phx.gbl.. .[color=blue]
> 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?
> InvestmentProdu ctID=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&MinInvestm ent=1&RSPEligib ility=2&cmdRefr esh=Refresh
> 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&MinInvestm ent=1&RSPEligib ility=2&cmdRefr esh=Refresh
> 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&MinInvestme nt=1&RSPEligibi lity=2&cmdRefre sh=Refresh
> 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&MinInvestme nt=0&RSPEligibi lity=2&cmdRefre sh=Refresh
> 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_pro ductdetails.a
> sp?InvestmentPr oductID=5X 19:55:04.647 93 240 Preproc
> headers 24.101.225.120 233802 ns 0un
> GEThttp://www.sny.ca/investing/institution_pro ductdetails.a
> sp?InvestmentPr oductID=5X 19:55:11.318 86 569
> Authentication 24.101.225.120 233832 ns 0
> unGEThttp://www.sny.ca/investing/institution_pro ductdetails
> .asp?Investment ProductID=12X 19:55:54.075 43 812
> Authentication 24.101.225.120 233958 ns 0
> unGEThttp://www.sny.ca/investing/search.asp?
> t=0&MinInvestme nt=0&RSPEligibi lity=0&OrderByR SP.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
> webmaster@sny.c a[/color]

**joe** · Jul 19 '05, 05:35 AM

Re: elminate the hanging processes

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_New sgroup_only.ple ase> wrote in message
news:OY1vV0yRDH A.2148@TK2MSFTN GP10.phx.gbl...[color=blue]
> Are you doing anything to help limit the impact of abandoned processes[/color]
where[color=blue]
> 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" <webmaster@sny. ca> wrote in message
> news:059f01c347 2b$ca5093b0$a10 1280a@phx.gbl.. .[color=green]
> > 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?
> > InvestmentProdu ctID=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&MinInvestm ent=1&RSPEligib ility=2&cmdRefr esh=Refresh
> > 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&MinInvestm ent=1&RSPEligib ility=2&cmdRefr esh=Refresh
> > 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&MinInvestme nt=1&RSPEligibi lity=2&cmdRefre sh=Refresh
> > 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&MinInvestme nt=0&RSPEligibi lity=2&cmdRefre sh=Refresh
> > 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_pro ductdetails.a
> > sp?InvestmentPr oductID=5X 19:55:04.647 93 240 Preproc
> > headers 24.101.225.120 233802 ns 0un
> > GEThttp://www.sny.ca/investing/institution_pro ductdetails.a
> > sp?InvestmentPr oductID=5X 19:55:11.318 86 569
> > Authentication 24.101.225.120 233832 ns 0
> > unGEThttp://www.sny.ca/investing/institution_pro ductdetails
> > .asp?Investment ProductID=12X 19:55:54.075 43 812
> > Authentication 24.101.225.120 233958 ns 0
> > unGEThttp://www.sny.ca/investing/search.asp?
> > t=0&MinInvestme nt=0&RSPEligibi lity=0&OrderByR SP.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
> > webmaster@sny.c a[/color]
>
>[/color]

**Simon** · Jul 19 '05, 05:35 AM

Re: elminate the hanging processes

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
webmaster@sny.c a
[color=blue]
>-----Original Message-----
>Are you doing anything to help limit the impact of[/color]
abandoned processes where[color=blue]
>the object hasn't been unloaded through your code?
>
>Not sure if that would cause your problem but it's worth[/color]
a thought.[color=blue]
>
>ASP.Net performs a cleanup for such things that I don't[/color]
believe ASP does.[color=blue]
>
>
>
>
>
>"Simon" <webmaster@sny. ca> wrote in message
>news:059f01c34 72b$ca5093b0$a1 01280a@phx.gbl. ..[color=green]
>> 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[/color][/color]
from[color=blue][color=green]
>> 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
>>[/color][/color]
http://www.sny.ca/investing/institut...ctdetails.asp?[color=blue][color=green]
>> InvestmentProdu ctID=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&MinInvestm ent=1&RSPEligib ility=2&cmdRefr esh=Refresh
>> 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&MinInvestm ent=1&RSPEligib ility=2&cmdRefr esh=Refresh
>> 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&MinInvestme nt=1&RSPEligibi lity=2&cmdRefre sh=Refresh
>> 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&MinInvestme nt=0&RSPEligibi lity=2&cmdRefre sh=Refresh
>> 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
>>[/color][/color]
GEThttp://www.sny.ca/investing/institution_pro ductdetails.a[color=blue][color=green]
>> sp?InvestmentPr oductID=5X 19:55:04.647 93 240[/color][/color]
Preproc[color=blue][color=green]
>> headers 24.101.225.120 233802 ns 0un
>>[/color][/color]
GEThttp://www.sny.ca/investing/institution_pro ductdetails.a[color=blue][color=green]
>> sp?InvestmentPr oductID=5X 19:55:11.318 86 569
>> Authentication 24.101.225.120 233832 ns 0
>>[/color][/color]
unGEThttp://www.sny.ca/investing/institution_pro ductdetails[color=blue][color=green]
>> .asp?Investment ProductID=12X 19:55:54.075 43 812
>> Authentication 24.101.225.120 233958 ns 0
>> unGEThttp://www.sny.ca/investing/search.asp?
>>[/color][/color]
t=0&MinInvestme nt=0&RSPEligibi lity=0&OrderByR SP.x=31&OrderB[color=blue][color=green]
>> yRSP.y=7
>>
>> I haven't a clue what all that means. My website used[/color][/color]
two[color=blue][color=green]
>> databases that i connected through without and ODBC
>> connection (i gave ADO the real path of the database[/color][/color]
file[color=blue][color=green]
>> 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[/color][/color]
on[color=blue][color=green]
>> all of the above listed files). I do not set them to[/color][/color]
null[color=blue][color=green]
>> 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
>> webmaster@sny.c a[/color]
>
>
>.
>[/color]

**Simon** · Jul 19 '05, 05:35 AM

Re: elminate the hanging processes

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 sConnectionStri ng
sConnectionSrin g = "Driver={Micros oft Access Driver
(*.mdb)};DBQ=" & Server.MapPath( "../cgi-bin/sny.mdb") & ";"

Dim rs
Set rs = Server.CreateOb ject("ADODB.rec ordset")
rs.Open "Institutions", sConnectionSrin g
rs.MoveFirst
Response.Write rs("Institution Name")
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?

[color=blue]
>-----Original Message-----
>Not only that but the connection to the database should[/color]
be closed while the[color=blue]
>user is working with the dataset.
>
>It sounds like your application is an ideal candidate for[/color]
upgrade to[color=blue]
>ASP.Net. vs just ASP.
>
>
>
>
>
>
>"Simon" <webmaster@sny. ca> wrote in message
>news:02a601c34 72f$df594370$a6 01280a@phx.gbl. ..[color=green]
>> If I understand you correctly, i think your asking if i[/color][/color]
do[color=blue][color=green]
>> anything to close the recordset or null the object
>> variables if the user hits the Stop button before the[/color][/color]
page[color=blue][color=green]
>> loads. If I'm right, the answer is no - how do i go[/color][/color]
about[color=blue][color=green]
>> doing that?
>>
>> Simon
>> webmaster@sny.c a
>>[color=darkred]
>> >-----Original Message-----
>> >Are you doing anything to help limit the impact of[/color]
>> abandoned processes where[color=darkred]
>> >the object hasn't been unloaded through your code?
>> >
>> >Not sure if that would cause your problem but it's[/color][/color][/color]
worth[color=blue][color=green]
>> a thought.[color=darkred]
>> >
>> >ASP.Net performs a cleanup for such things that I don't[/color]
>> believe ASP does.[color=darkred]
>> >
>> >
>> >
>> >
>> >
>> >"Simon" <webmaster@sny. ca> wrote in message
>> >news:059f01c34 72b$ca5093b0$a1 01280a@phx.gbl. ..
>> >> My webhosting company cut off my website the other[/color][/color][/color]
day[color=blue][color=green][color=darkred]
>> >> because i had "too many hanging processes"
>> >>
>> >> What does this mean and what can i do to prevent this[/color]
>> from[color=darkred]
>> >> 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
>> >>[/color]
>>[/color][/color]
http://www.sny.ca/investing/institut...ctdetails.asp?[color=blue][color=green][color=darkred]
>> >> InvestmentProdu ctID=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?
>> >>[/color][/color][/color]
t=30&MinInvestm ent=1&RSPEligib ility=2&cmdRefr esh=Refresh[color=blue][color=green][color=darkred]
>> >> 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?
>> >>[/color][/color][/color]
t=30&MinInvestm ent=1&RSPEligib ility=2&cmdRefr esh=Refresh[color=blue][color=green][color=darkred]
>> >> 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?
>> >>[/color][/color][/color]
t=0&MinInvestme nt=1&RSPEligibi lity=2&cmdRefre sh=Refresh[color=blue][color=green][color=darkred]
>> >> 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?
>> >>[/color][/color][/color]
t=0&MinInvestme nt=0&RSPEligibi lity=2&cmdRefre sh=Refresh[color=blue][color=green][color=darkred]
>> >> 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
>> >>[/color]
>>[/color][/color]
GEThttp://www.sny.ca/investing/institution_pro ductdetails.a[color=blue][color=green][color=darkred]
>> >> sp?InvestmentPr oductID=5X 19:55:04.647 93 240[/color]
>> Preproc[color=darkred]
>> >> headers 24.101.225.120 233802 ns 0un
>> >>[/color]
>>[/color][/color]
GEThttp://www.sny.ca/investing/institution_pro ductdetails.a[color=blue][color=green][color=darkred]
>> >> sp?InvestmentPr oductID=5X 19:55:11.318 86 569
>> >> Authentication 24.101.225.120 233832 ns 0
>> >>[/color]
>>[/color][/color]
unGEThttp://www.sny.ca/investing/institution_pro ductdetails[color=blue][color=green][color=darkred]
>> >> .asp?Investment ProductID=12X 19:55:54.075 43 812
>> >> Authentication 24.101.225.120 233958 ns 0
>> >> unGEThttp://www.sny.ca/investing/search.asp?
>> >>[/color]
>>[/color][/color]
t=0&MinInvestme nt=0&RSPEligibi lity=0&OrderByR SP.x=31&OrderB[color=blue][color=green][color=darkred]
>> >> yRSP.y=7
>> >>
>> >> I haven't a clue what all that means. My website used[/color]
>> two[color=darkred]
>> >> databases that i connected through without and ODBC
>> >> connection (i gave ADO the real path of the database[/color]
>> file[color=darkred]
>> >> 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[/color][/color][/color]
(used[color=blue][color=green]
>> on[color=darkred]
>> >> all of the above listed files). I do not set them to[/color]
>> null[color=darkred]
>> >> at the end of hte asp file - should i?
>> >>
>> >> Anything else?
>> >>
>> >> I know in VB i can use the Unload command to unload[/color][/color][/color]
the[color=blue][color=green][color=darkred]
>> >> form, and i can use hte END command to end the[/color][/color][/color]
program[color=blue][color=green][color=darkred]
>> >> (albiet a crude way of doing so), is there anything[/color][/color][/color]
like[color=blue][color=green][color=darkred]
>> >> this in asp?
>> >>
>> >> please help!
>> >>
>> >> Siomn
>> >> webmaster@sny.c a
>> >
>> >
>> >.
>> >[/color][/color]
>
>
>.
>[/color]

**Bob Barrows** · Jul 19 '05, 05:36 AM

Re: elminate the hanging processes

Don't forget
Set rs = nothing
This is vital.

Bob Barrows
Simon wrote:[color=blue]
> 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 sConnectionStri ng
> sConnectionSrin g = "Driver={Micros oft Access Driver
> (*.mdb)};DBQ=" & Server.MapPath( "../cgi-bin/sny.mdb") & ";"
>
> Dim rs
> Set rs = Server.CreateOb ject("ADODB.rec ordset")
> rs.Open "Institutions", sConnectionSrin g
> rs.MoveFirst
> Response.Write rs("Institution Name")
> 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?
>
>[color=green]
>> -----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" <webmaster@sny. ca> wrote in message
>> news:02a601c347 2f$df594370$a60 1280a@phx.gbl.. .[color=darkred]
>>> 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
>>> webmaster@sny.c a
>>>
>>>> -----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" <webmaster@sny. ca> wrote in message
>>>> news:059f01c347 2b$ca5093b0$a10 1280a@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
>>>>>
>>>[/color][/color]
> http://www.sny.ca/investing/institut...ctdetails.asp?[color=green][color=darkred]
>>>>> InvestmentProdu ctID=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?
>>>>>[/color][/color]
> t=30&MinInvestm ent=1&RSPEligib ility=2&cmdRefr esh=Refresh[color=green][color=darkred]
>>>>> 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?
>>>>>[/color][/color]
> t=30&MinInvestm ent=1&RSPEligib ility=2&cmdRefr esh=Refresh[color=green][color=darkred]
>>>>> 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?
>>>>>[/color][/color]
> t=0&MinInvestme nt=1&RSPEligibi lity=2&cmdRefre sh=Refresh[color=green][color=darkred]
>>>>> 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?
>>>>>[/color][/color]
> t=0&MinInvestme nt=0&RSPEligibi lity=2&cmdRefre sh=Refresh[color=green][color=darkred]
>>>>> 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
>>>>>
>>>[/color][/color]
> GEThttp://www.sny.ca/investing/institution_pro ductdetails.a[color=green][color=darkred]
>>>>> sp?InvestmentPr oductID=5X 19:55:04.647 93 240 Preproc
>>>>> headers 24.101.225.120 233802 ns 0un
>>>>>
>>>[/color][/color]
> GEThttp://www.sny.ca/investing/institution_pro ductdetails.a[color=green][color=darkred]
>>>>> sp?InvestmentPr oductID=5X 19:55:11.318 86 569
>>>>> Authentication 24.101.225.120 233832 ns 0
>>>>>
>>>[/color][/color]
> unGEThttp://www.sny.ca/investing/institution_pro ductdetails[color=green][color=darkred]
>>>>> .asp?Investment ProductID=12X 19:55:54.075 43 812
>>>>> Authentication 24.101.225.120 233958 ns 0
>>>>> unGEThttp://www.sny.ca/investing/search.asp?
>>>>>
>>>[/color][/color]
> t=0&MinInvestme nt=0&RSPEligibi lity=0&OrderByR SP.x=31&OrderB[color=green][color=darkred]
>>>>> 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
>>>>> webmaster@sny.c a
>>>>
>>>>
>>>> .
>>>>[/color]
>>
>>
>> .[/color][/color]

**Simon** · Jul 19 '05, 05:36 AM

Re: elminate the hanging processes

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
[color=blue]
>-----Original Message-----
>It's been reported as being a leading cause of memory[/color]
leaks which can lead[color=blue]
>to "hung" servers.
>
>Bob
>
>Simon wrote:[color=green]
>> 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?
>>[color=darkred]
>>> -----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[/color][/color][/color]
i'm[color=blue][color=green][color=darkred]
>>>> just trying to make do for now.
>>>>
>>>> As for my host they're not saying. They're only[/color][/color][/color]
response[color=blue][color=green][color=darkred]
>>>> is "everything we found is explained up there (in the[/color][/color][/color]
IIS[color=blue][color=green][color=darkred]
>>>> Trace readout)" and "you need to ask your programmer[/color][/color][/color]
that".[color=blue][color=green][color=darkred]
>>>>
>>>> I can easily quote them because their only means[/color]
>> of "real-[color=darkred]
>>>> time" tech support is through IM. - You get what you[/color][/color][/color]
pay[color=blue][color=green][color=darkred]
>>>> for.
>>>>
>>>> As for the database, i dont create a database[/color][/color][/color]
object... i[color=blue][color=green][color=darkred]
>>>> open the recordset as follows....
>>>>
>>>> <html>
>>>> <body>
>>>> <%
>>>> Option Explicit
>>>>
>>>> Dim sConnectionStri ng
>>>> sConnectionSrin g = "Driver={Micros oft Access Driver
>>>> (*.mdb)};DBQ=" & Server.MapPath( "../cgi-bin/sny.mdb")[/color]
>> & ";"[color=darkred]
>>>>
>>>> Dim rs
>>>> Set rs = Server.CreateOb ject("ADODB.rec ordset")
>>>> rs.Open "Institutions", sConnectionSrin g
>>>> rs.MoveFirst
>>>> Response.Write rs("Institution Name")
>>>> rs.Close
>>>>
>>>> %>
>>>> </body>
>>>> </html>
>>>>
>>>>
>>>> Well okay, maybe my webpages arn't that dull, but[/color][/color][/color]
besides[color=blue][color=green][color=darkred]
>>>> the standard html, thats about it. Anything i can do[/color][/color][/color]
to[color=blue][color=green][color=darkred]
>>>> keep "this is unacceptable" website from crashing?
>>>>
>>>>
>>>>> -----Original Message-----
>>>>> Not only that but the connection to the database[/color][/color][/color]
should be closed[color=blue][color=green][color=darkred]
>>>>> while the user is working with the dataset.
>>>>>
>>>>> It sounds like your application is an ideal[/color][/color][/color]
candidate for upgrade[color=blue][color=green][color=darkred]
>>>>> to ASP.Net. vs just ASP.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> "Simon" <webmaster@sny. ca> wrote in message
>>>>> news:02a601c347 2f$df594370$a60 1280a@phx.gbl.. .
>>>>>> If I understand you correctly, i think your asking[/color][/color][/color]
if i do[color=blue][color=green][color=darkred]
>>>>>> anything to close the recordset or null the object
>>>>>> variables if the user hits the Stop button before[/color][/color][/color]
the page[color=blue][color=green][color=darkred]
>>>>>> loads. If I'm right, the answer is no - how do i go[/color][/color][/color]
about[color=blue][color=green][color=darkred]
>>>>>> doing that?
>>>>>>
>>>>>> Simon
>>>>>> webmaster@sny.c a
>>>>>>
>>>>>>> -----Original Message-----
>>>>>>> Are you doing anything to help limit the impact of[/color][/color][/color]
abandoned[color=blue][color=green][color=darkred]
>>>>>>> processes where the object hasn't been unloaded[/color][/color][/color]
through your[color=blue][color=green][color=darkred]
>>>>>>> code?
>>>>>>>
>>>>>>> Not sure if that would cause your problem but it's[/color][/color][/color]
worth a[color=blue][color=green][color=darkred]
>>>>>>> thought.
>>>>>>>
>>>>>>> ASP.Net performs a cleanup for such things that I[/color][/color][/color]
don't believe[color=blue][color=green][color=darkred]
>>>>>>> ASP does.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> "Simon" <webmaster@sny. ca> wrote in message
>>>>>>> news:059f01c347 2b$ca5093b0$a10 1280a@phx.gbl.. .
>>>>>>>> My webhosting company cut off my website the[/color][/color][/color]
other day[color=blue][color=green][color=darkred]
>>>>>>>> because i had "too many hanging processes"
>>>>>>>>
>>>>>>>> What does this mean and what can i do to prevent[/color][/color][/color]
this from[color=blue][color=green][color=darkred]
>>>>>>>> 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
>>>>>>>>
>>>>>>
>>>>[/color]
>>[/color][/color]
http://www.sny.ca/investing/institut...ctdetails.asp?[color=blue][color=green][color=darkred]
>>>>>>>> InvestmentProdu ctID=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?
>>>>>>>>
>>>>[/color][/color][/color]
t=30&MinInvestm ent=1&RSPEligib ility=2&cmdRefr esh=Refresh[color=blue][color=green][color=darkred]
>>>>>>>> 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?
>>>>>>>>
>>>>[/color][/color][/color]
t=30&MinInvestm ent=1&RSPEligib ility=2&cmdRefr esh=Refresh[color=blue][color=green][color=darkred]
>>>>>>>> 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?
>>>>>>>>
>>>>[/color][/color][/color]
t=0&MinInvestme nt=1&RSPEligibi lity=2&cmdRefre sh=Refresh[color=blue][color=green][color=darkred]
>>>>>>>> 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?
>>>>>>>>
>>>>[/color][/color][/color]
t=0&MinInvestme nt=0&RSPEligibi lity=2&cmdRefre sh=Refresh[color=blue][color=green][color=darkred]
>>>>>>>> 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[/color][/color][/color]
Preproc[color=blue][color=green][color=darkred]
>>>>>>>> headers 24.101.225.120 232810 ns 0un
>>>>>>>>
>>>>>>
>>>>[/color]
>>[/color][/color]
GEThttp://www.sny.ca/investing/institution_pro ductdetails.a[color=blue][color=green][color=darkred]
>>>>>>>> sp?InvestmentPr oductID=5X 19:55:04.647 93 240[/color][/color][/color]
Preproc[color=blue][color=green][color=darkred]
>>>>>>>> headers 24.101.225.120 233802 ns 0un
>>>>>>>>
>>>>>>
>>>>[/color]
>>[/color][/color]
GEThttp://www.sny.ca/investing/institution_pro ductdetails.a[color=blue][color=green][color=darkred]
>>>>>>>> sp?InvestmentPr oductID=5X 19:55:11.318 86 569
>>>>>>>> Authentication 24.101.225.120 233832 ns 0
>>>>>>>>
>>>>>>
>>>>[/color]
>>[/color][/color]
unGEThttp://www.sny.ca/investing/institution_pro ductdetails[color=blue][color=green][color=darkred]
>>>>>>>> .asp?Investment ProductID=12X 19:55:54.075 43 812
>>>>>>>> Authentication 24.101.225.120 233958 ns 0
>>>>>>>> unGEThttp://www.sny.ca/investing/search.asp?
>>>>>>>>
>>>>>>
>>>>[/color]
>>[/color][/color]
t=0&MinInvestme nt=0&RSPEligibi lity=0&OrderByR SP.x=31&OrderB[color=blue][color=green][color=darkred]
>>>>>>>> yRSP.y=7
>>>>>>>>
>>>>>>>> I haven't a clue what all that means. My website[/color][/color][/color]
used two[color=blue][color=green][color=darkred]
>>>>>>>> databases that i connected through without and[/color][/color][/color]
ODBC[color=blue][color=green][color=darkred]
>>>>>>>> connection (i gave ADO the real path of the[/color][/color][/color]
database file[color=blue][color=green][color=darkred]
>>>>>>>> on every open)
>>>>>>>>
>>>>>>>> The typial website had about 5-10 include files[/color][/color][/color]
and i[color=blue][color=green][color=darkred]
>>>>>>>> always closed my rs at the end of every asp file.
>>>>>>>>
>>>>>>>> Throughout the site i use the CreateObject method[/color][/color][/color]
(used on[color=blue][color=green][color=darkred]
>>>>>>>> all of the above listed files). I do not set them[/color][/color][/color]
to null[color=blue][color=green][color=darkred]
>>>>>>>> at the end of hte asp file - should i?
>>>>>>>>
>>>>>>>> Anything else?
>>>>>>>>
>>>>>>>> I know in VB i can use the Unload command to[/color][/color][/color]
unload the[color=blue][color=green][color=darkred]
>>>>>>>> form, and i can use hte END command to end the[/color][/color][/color]
program[color=blue][color=green][color=darkred]
>>>>>>>> (albiet a crude way of doing so), is there[/color][/color][/color]
anything like[color=blue][color=green][color=darkred]
>>>>>>>> this in asp?
>>>>>>>>
>>>>>>>> please help!
>>>>>>>>
>>>>>>>> Siomn
>>>>>>>> webmaster@sny.c a
>>>>>>>
>>>>>>>
>>>>>>> .
>>>>>>>
>>>>>
>>>>>
>>>>> .
>>>
>>>
>>>
>>> .[/color][/color]
>
>
>
>.
>[/color]

**Randy R** · Jul 19 '05, 05:36 AM

Re: elminate the hanging processes

> I'd love to upgrade, but i cant afford VStudio.NET so i'm[color=blue]
> just trying to make do for now.[/color]

Surely you can afford notepad or web matrix (http://www.asp.net).

elminate the hanging processes

elminate the hanging processes

Comment

Comment

Comment

Comment

Comment

Comment

Comment