By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,463 Members | 774 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,463 IT Pros & Developers. It's quick & easy.

Close RS... "DLLHOST.EXE"

P: n/a
Hello Group,

I have had an issue on my server for a long time and what ever I have tryed
I just cant fix it.

I run mySQL and IIS, and my server will crash every few days because a file
on the server called DLLHOST.EXE has taken all the memory, and the mySQL
goes off line.

I close all of the record sets, and all of the Text files I read, as below

========
set fso = createobject("scripting.filesystemobject")
set act = fso.opentextfile(server.mappath ("/counters/year_count-"&
year(date())&".txt"))
countery = clng(act.readline)
countery = countery + 1
act.close
fso.close
========
============
strQuery = "SELECT * FROM category WHERE CATEGORY_ID='"&top_id&"';"
Set rscateinfo = adoConn.Execute(strQuery)

Do While Not rscateinfo.EOF

leveltop=rscateinfo("name").Value
leveltopurl=rscateinfo("link_url").Value

rscateinfo.MoveNext
loop
rscateinfo.close
set rscateinfo = Nothing
=============

each page I open the DLLHOST.EXE will will grow anything upto 150K per
page.. in the SQL example above the table for category has 35 columns, would
it make any differnace to memory if I selected the fields rather than all of
the fields from the in SELECT * FROM

The only solution I can come up with now is to buy more memory, but I am
sure I must be doing someting wrong.

Do I have to close the varables I have opened to stop this memory leek ????

Kind Regards

Graham Mattingley

Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Make sure you close all the objects you are opening, dllhost.exe is nothing
but the one which actually runs your asp. so there should be something wrong
in the asp code thats causing load on that file.

"Graham Mattingley" <gr****@technocom.com> wrote in message
news:bh*******************@news.demon.co.uk...
Hello Group,

I have had an issue on my server for a long time and what ever I have tryed I just cant fix it.

I run mySQL and IIS, and my server will crash every few days because a file on the server called DLLHOST.EXE has taken all the memory, and the mySQL
goes off line.

I close all of the record sets, and all of the Text files I read, as below

========
set fso = createobject("scripting.filesystemobject")
set act = fso.opentextfile(server.mappath ("/counters/year_count-"&
year(date())&".txt"))
countery = clng(act.readline)
countery = countery + 1
act.close
fso.close
========
============
strQuery = "SELECT * FROM category WHERE CATEGORY_ID='"&top_id&"';"
Set rscateinfo = adoConn.Execute(strQuery)

Do While Not rscateinfo.EOF

leveltop=rscateinfo("name").Value
leveltopurl=rscateinfo("link_url").Value

rscateinfo.MoveNext
loop
rscateinfo.close
set rscateinfo = Nothing
=============

each page I open the DLLHOST.EXE will will grow anything upto 150K per
page.. in the SQL example above the table for category has 35 columns, would it make any differnace to memory if I selected the fields rather than all of the fields from the in SELECT * FROM

The only solution I can come up with now is to buy more memory, but I am
sure I must be doing someting wrong.

Do I have to close the varables I have opened to stop this memory leek ????
Kind Regards

Graham Mattingley

Jul 19 '05 #2

P: n/a
I don't see any code to close and destroy your connections. That needs to be
done as well.

Bob Barrows
Graham Mattingley wrote:
Hello Group,

I have had an issue on my server for a long time and what ever I have
tryed I just cant fix it.

I run mySQL and IIS, and my server will crash every few days because
a file on the server called DLLHOST.EXE has taken all the memory, and
the mySQL goes off line.

I close all of the record sets, and all of the Text files I read, as
below

========
set fso = createobject("scripting.filesystemobject")
set act = fso.opentextfile(server.mappath ("/counters/year_count-"&
year(date())&".txt"))
countery = clng(act.readline)
countery = countery + 1
act.close
fso.close
========
============
strQuery = "SELECT * FROM category WHERE CATEGORY_ID='"&top_id&"';"
Set rscateinfo = adoConn.Execute(strQuery)

Do While Not rscateinfo.EOF

leveltop=rscateinfo("name").Value
leveltopurl=rscateinfo("link_url").Value

rscateinfo.MoveNext
loop
rscateinfo.close
set rscateinfo = Nothing
=============

each page I open the DLLHOST.EXE will will grow anything upto 150K per
page.. in the SQL example above the table for category has 35
columns, would it make any differnace to memory if I selected the
fields rather than all of the fields from the in SELECT * FROM

The only solution I can come up with now is to buy more memory, but I
am sure I must be doing someting wrong.

Do I have to close the varables I have opened to stop this memory
leek ????

Kind Regards

Graham Mattingley

Jul 19 '05 #3

P: n/a
Thanks for that reply.....

I have a few 100 ASP pages on my server, is the DLLHOST.EXE file supposed to
grow in size at all, I have closed all of the objects and connections, and
when I refresh the same page 10 times, the file will grow by a 125K per
refresh

is the ASP complied page cached in the DLLHOST.EXE file ??

Kind Regards

Graham Mattingley


"vivek" <vi********@yahoo.com> wrote in message
news:e5**************@TK2MSFTNGP12.phx.gbl...
Make sure you close all the objects you are opening, dllhost.exe is nothing but the one which actually runs your asp. so there should be something wrong in the asp code thats causing load on that file.

"Graham Mattingley" <gr****@technocom.com> wrote in message
news:bh*******************@news.demon.co.uk...
Hello Group,

I have had an issue on my server for a long time and what ever I have tryed
I just cant fix it.

I run mySQL and IIS, and my server will crash every few days because a

file
on the server called DLLHOST.EXE has taken all the memory, and the mySQL
goes off line.

I close all of the record sets, and all of the Text files I read, as below
========
set fso = createobject("scripting.filesystemobject")
set act = fso.opentextfile(server.mappath ("/counters/year_count-"&
year(date())&".txt"))
countery = clng(act.readline)
countery = countery + 1
act.close
fso.close
========
============
strQuery = "SELECT * FROM category WHERE CATEGORY_ID='"&top_id&"';"
Set rscateinfo = adoConn.Execute(strQuery)

Do While Not rscateinfo.EOF

leveltop=rscateinfo("name").Value
leveltopurl=rscateinfo("link_url").Value

rscateinfo.MoveNext
loop
rscateinfo.close
set rscateinfo = Nothing
=============

each page I open the DLLHOST.EXE will will grow anything upto 150K per
page.. in the SQL example above the table for category has 35 columns,

would
it make any differnace to memory if I selected the fields rather than

all of
the fields from the in SELECT * FROM

The only solution I can come up with now is to buy more memory, but I am
sure I must be doing someting wrong.

Do I have to close the varables I have opened to stop this memory leek

????

Kind Regards

Graham Mattingley


Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.