Re: Memory Leak

Michael Peppler <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.sybase
Message-ID <[email protected]>
On Tue, 2004-11-16 at 22:06, Anton Ganeshalingam wrote:
> I'm using Sybperl 2.151 on win 2000. Everytime I insert like 10, 000
> records into  a table, one at time, I see the memory useage increase and
> it never goes down. I'm using $dbh2->ct_execute($sql) in a while loop.
> Also my main application runs every 30 mintues  in while loop.

Does your code reconnect to the server each time through the main loop?

If yes, then that is the source of the leak - it's a known problem that
I haven't been able to solve yet.

Michael
-- 
Michael Peppler                              Data Migrations, Inc.
[email protected]                       http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or 
long term contract positions - http://www.peppler.org/resume.html
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.