PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: Memory Leak
Date: Nov 17 2004 8:16AM

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.
mpeppler@peppler.org                       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