Hi, All
I have a legacy ASP application, which is full of memory leaks. The source
of the leaks are ADO objects that were not closed.
For exapmle "Open" recordset without "Close" and so on.
As the application is rather big, manually parsing asp code is rather
painfully.
Are there any asp code parsing tools, to analyze the source code?
TIA
--
Vadym Stetsyak 4 2144
"Vadym Stetsyak" wrote in message
news:eU***************@TK2MSFTNGP10.phx.gbl...
: I have a legacy ASP application, which is full of memory leaks. The source
: of the leaks are ADO objects that were not closed.
: For exapmle "Open" recordset without "Close" and so on.
:
: As the application is rather big, manually parsing asp code is rather
: painfully.
:
: Are there any asp code parsing tools, to analyze the source code?
Not sure but objects are defined with the word 'set'. So it shouldn't be
that hard to find them.
--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp
Yes, that is not too difficult.
Also when you call Open for the recordset object and do not call Close it is
the source of mem leaks.
So to detect the mem leak I have to debug the page under different
conditions, it takes time. That is why I posted this message, about code
analyzers...
"Roland Hall" <nobody@nowhere> wrote in message
news:#4**************@TK2MSFTNGP14.phx.gbl... "Vadym Stetsyak" wrote in message news:eU***************@TK2MSFTNGP10.phx.gbl... : I have a legacy ASP application, which is full of memory leaks. The
source : of the leaks are ADO objects that were not closed. : For exapmle "Open" recordset without "Close" and so on. : : As the application is rather big, manually parsing asp code is rather : painfully. : : Are there any asp code parsing tools, to analyze the source code?
Not sure but objects are defined with the word 'set'. So it shouldn't be that hard to find them.
-- Roland Hall /* This information is distributed in the hope that it will be useful, but without any warranty; without even the implied warranty of merchantability or fitness for a particular purpose. */ Technet Script Center - http://www.microsoft.com/technet/scriptcenter/ WSH 5.6 Documentation -
http://msdn.microsoft.com/downloads/list/webdev.asp MSDN Library - http://msdn.microsoft.com/library/default.asp
Gazing into my crystal ball I observed "Vadym Stetsyak" <va*****@ukr.net>
writing in news:#Y**************@TK2MSFTNGP14.phx.gbl: Yes, that is not too difficult. Also when you call Open for the recordset object and do not call Close it is the source of mem leaks.
So to detect the mem leak I have to debug the page under different conditions, it takes time. That is why I posted this message, about code analyzers...
You could roll your own. Using FSO, you could read the files and search
for ".Open". If ".Open" was found, then search for ".Close". If ".Close"
was not found, then you could find the name of the recordset using MID
function, and then write to the document. Just a thought, not tested.
"Roland Hall" <nobody@nowhere> wrote in message news:#4**************@TK2MSFTNGP14.phx.gbl... "Vadym Stetsyak" wrote in message news:eU***************@TK2MSFTNGP10.phx.gbl... : I have a legacy ASP application, which is full of memory leaks. The : source of the leaks are ADO objects that were not closed. : For exapmle "Open" recordset without "Close" and so on. : : As the application is rather big, manually parsing asp code is : rather painfully. : : Are there any asp code parsing tools, to analyze the source code?
Not sure but objects are defined with the word 'set'. So it shouldn't be that hard to find them.
-- Roland Hall /* This information is distributed in the hope that it will be useful, but without any warranty; without even the implied warranty of merchantability or fitness for a particular purpose. */ Technet Script Center - http://www.microsoft.com/technet/scriptcenter/ WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp MSDN Library - http://msdn.microsoft.com/library/default.asp
--
Adrienne Boswell http://www.cavalcade-of-coding.info
Please respond to the group so others can share
At first I thought of something like injecting additional code
after the "Set", "Open", "Close" statements
the code would be something like
Server.Execute("report.asp?page=test.asp&line=34&v ar=rs&action=open")
and on report.asp gather the statistics. It will be like obtaining dynamic
call stack of the page.
We can parse an asp file statically, but we shall not be able to reproduce
dynamic behavior ( conditions based on some values and so on )
"Adrienne" <ar********@sbcglobal.net> wrote in message
news:Xn****************************@207.115.63.158 ... Gazing into my crystal ball I observed "Vadym Stetsyak" <va*****@ukr.net> writing in news:#Y**************@TK2MSFTNGP14.phx.gbl:
Yes, that is not too difficult. Also when you call Open for the recordset object and do not call Close it is the source of mem leaks.
So to detect the mem leak I have to debug the page under different conditions, it takes time. That is why I posted this message, about code analyzers...
You could roll your own. Using FSO, you could read the files and search for ".Open". If ".Open" was found, then search for ".Close". If ".Close" was not found, then you could find the name of the recordset using MID function, and then write to the document. Just a thought, not tested.
"Roland Hall" <nobody@nowhere> wrote in message news:#4**************@TK2MSFTNGP14.phx.gbl... "Vadym Stetsyak" wrote in message news:eU***************@TK2MSFTNGP10.phx.gbl... : I have a legacy ASP application, which is full of memory leaks. The : source of the leaks are ADO objects that were not closed. : For exapmle "Open" recordset without "Close" and so on. : : As the application is rather big, manually parsing asp code is : rather painfully. : : Are there any asp code parsing tools, to analyze the source code?
Not sure but objects are defined with the word 'set'. So it shouldn't be that hard to find them.
-- Roland Hall /* This information is distributed in the hope that it will be useful, but without any warranty; without even the implied warranty of merchantability or fitness for a particular purpose. */ Technet Script Center - http://www.microsoft.com/technet/scriptcenter/ WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp MSDN Library - http://msdn.microsoft.com/library/default.asp
-- Adrienne Boswell http://www.cavalcade-of-coding.info Please respond to the group so others can share This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Warren Wright |
last post by:
Hi group,
I have a select statement that if run against a 1 million record
database directly in query analyzer takes less than 1 second.
However, if I execute the select statement in a stored...
|
by: Matt |
last post by:
Hello
I have spent the last weeks trying to solve this problem but with no
luck at all, I have a piece of code that looks like this
declare @bestnr int,
@artnr varchar(25),
@journalnrrow...
|
by: Poster |
last post by:
After creating an IN clause from a bunch of character strings created by a
Word macro, Query Analyzer complains about a syntax error. The macro takes a
column full of character strings and wraps...
|
by: JM |
last post by:
Good day. I was able to connect to a database server using SQL Server
Enterprise Manager. The Server name specified on the tree is
JOMARGON(Windows NT). But no server was detected using either...
|
by: justinjoylife |
last post by:
Hi -
I'm completely new to Microsoft Query Analyzer and I need to learn it
for work to do data mining as a Product Manager. Does anyone have any
recommendations on how to learn this and where?...
|
by: Assertor |
last post by:
Hi, All.
I'd like to get a code analyzer (not parser) for c/c++ header file.
I've search through web, I could not.
The funcitonlaity of the analyzer is as following,
- in case of c
Can get...
|
by: siddharthkhare |
last post by:
Hi All,
I need to parse certain text from a paragraph (like 20 lines).
I know the exact tags that I am looking for.
my approach is to define a xml (config) file that defines what tag I am...
|
by: ravi4udude |
last post by:
hi All,
If anyone have this software please share it with me.
Thanks in advance.
|
by: Kevin G. Anderson |
last post by:
What: CAUG Meeting - QuickBooks IIF Files; Total Access Analyzer; CAUG
Social
When: Thursday, May 25, 2006, 6PM
Who: Chris Monaghan and Kevin Anderson
Where: The Information Management Group...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |