473,396 Members | 1,775 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,396 software developers and data experts.

asp code parser and analyzer

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
Jul 22 '05 #1
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
Jul 22 '05 #2
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

Jul 22 '05 #3
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
Jul 22 '05 #4
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

Jul 22 '05 #5

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

Similar topics

5
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...
1
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...
2
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...
3
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...
1
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?...
2
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...
4
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...
4
by: ravi4udude | last post by:
hi All, If anyone have this software please share it with me. Thanks in advance.
14
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...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
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...
0
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
0
BarryA
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...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
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...
0
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...
0
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...
0
agi2029
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,...

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.