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 2154
"Vadym Stetsyak" wrote in message
news:eU******** *******@TK2MSFT NGP10.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******** ******@TK2MSFTN GP14.phx.gbl... "Vadym Stetsyak" wrote in message news:eU******** *******@TK2MSFT NGP10.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.ne t>
writing in news:#Y******** ******@TK2MSFTN GP14.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******** ******@TK2MSFTN GP14.phx.gbl... "Vadym Stetsyak" wrote in message news:eU******** *******@TK2MSFT NGP10.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?pag e=test.asp&line =34&var=rs&acti on=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********@sbc global.net> wrote in message
news:Xn******** *************** *****@207.115.6 3.158... Gazing into my crystal ball I observed "Vadym Stetsyak" <va*****@ukr.ne t> writing in news:#Y******** ******@TK2MSFTN GP14.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******** ******@TK2MSFTN GP14.phx.gbl... "Vadym Stetsyak" wrote in message news:eU******** *******@TK2MSFT NGP10.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 procedure
instead, calling the stored proc from query analyzer, then it takes
12-17 seconds.
Here is what I execute in Query Analyzer when bypassing the stored
procedure:
|
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 int,
@bestlevant decimal,
|
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 apostrophes (single-quotes)
around each string and adds a comma to the end of each line, ready to paste
into a Query Analyzer session. The problem is that Query Analyzer doesn't
recognize the MS-Word apostrophes. It has nothing to do with the...
|
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 Visual
Studio .NET and SQL Server's query analyzer.
I highlighted one database (master) on the SQL Server Enterprise
Manager and chose 'SQL Query Analyzer' under the 'Tools' menu. It
worked. The Title of the Query Analyzer window is
SQL Server...
|
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? Which books? What
classes? What links to online tutorials?
thanks
| |
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 the list of declaration of functions.
- in case of c++
|
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
looking for and corresponding regular expression to search for the
pattern.
Xml file will also have a way to say what should be the pervious tag
|
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
200 W. Monroe St. Suite 900
Chicago, IL 60606
(312) 222-9400
Location: www.imginc.com/IMG/About+IMG/chicago.htm
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |