Is the DBHandler not re-using the memory it allocated the first time
around?  Sounds like when you create the handler every iteration, it's
just ignoring the memory it used from the previous iteration and
allocating more memory...

---------------------------
Jason H. Frisvold
Senior ATM Engineer
Engineering Dept.
Penteledata
CCNA Certified - CSCO10151622
[EMAIL PROTECTED]
---------------------------
"Imagination is more important than knowledge. Knowledge is limited.
Imagination encircles the world." -- Albert Einstein [1879-1955]


-----Original Message-----
From: Rune Hegrenes [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, May 02, 2002 6:45 AM
To: Jonathan E. Paton; [EMAIL PROTECTED]
Subject: Re: SybPerl - Memory leaks

The same thing happens when I comment out the checks.
The script uses more memory when I connect to the database:

    $dbh = new Sybase::DBlib $userid, $password, $host;
    $dbh->dbuse($database);

Rune

----- Original Message ----- 
From: "Jonathan E. Paton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 02, 2002 12:31 PM
Subject: Re: SybPerl - Memory leaks


> > The script is not smallish, but the main loop looks like this:
> > 
> > {
> >     # Connecting
> >     $dbh = new Sybase::DBlib $userid, $password, $host;
> >     $dbh->dbuse($database);
> > 
> >     # Checking
> >     checkProsesses();
> >     checkSegmentStatus();
> >     getMonitor();
> > 
> >     # Disconnecting
> >     $dbh->dbclose;
> > }
> 
> Okay, it might seem obvious but what happens when you comment
> out the checks?  Can you reduce the problem down, at all?  The
> three functions are independant, right?  (Hoping that nobody
> is returning results using global variables... again).
> 
> Jonathan Paton
> 
> __________________________________________________
> Do You Yahoo!?
> Everything you'll ever need on one web page
> from News and Sport to Email and Music Charts
> http://uk.my.yahoo.com
> 
> -- 
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 


-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to