Curt Russell Crandall writes:
> I'm having a problem with my program having its memory usage go out of
> control. I'm working on Solairs 2.5.1 and 2.6 with several Perl builds:
>
> Perl 5.00404 w/ DBI 1.13 & DBD::Sybase 0.21
> Perl 5.00404 w/ DBI 1.14 & DBD::Sybase 0.91
> Perl 5.6.0 w/ DBI 1.14 & DBD::Sybase 0.91
> Since Sybase can't have a database handle with multiple statement handles
> with AutoCommit off, I'm creating 2 database handles. The one with
> AutoCommit off is used for selects and for the insert mentioned
> above. The other handle is used to insert the output structure into the
> database... I'm caching every 100 transactions between commits.
The leak is that you have simultaneous active statement handles on a
single database handle. This causes DBD::Sybase to open a new
connection for each secondary $sth, and this is where you have a
leak. I *suspect* that this leak is in OpenClient, but it is also
possible that it is in DBD::Sybase itself (although there is no leak
if you don't need to open additional connections when creating
statement handles).
Michael
--
Michael Peppler - Data Migrations Inc. - [EMAIL PROTECTED]
http://www.mbay.net/~mpeppler - [EMAIL PROTECTED]
International Sybase User Group - http://www.isug.com
*Looking for new project to tackle starting 8/1/01*
