Home > Archive > PERL POE > June 2007 > EasyDBI replacement!
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
EasyDBI replacement!
|
|
| Zack Payton 2007-06-19, 7:27 pm |
| Hello all,
I've been using EasyDBI for some time, and I just realized it was the source
of some memory leaks... as I search the internet I find that it's a known
issue. Doe!
Can anyone recommend a cross platform replacement? Hopefully something that
will work on Windows and Linux.
Thank you!
Z
| |
| Zack Payton 2007-06-19, 7:27 pm |
| Correction:
Known issue misreported:
http://www.annocpan.org/~DSNOPEK/PO...MessageQueue.pm
You're right it is silly, but timing is off the essence, and a replacement
is more viable at this point. Perhaps you could offer some tips for
tracking down memory leaks beyond the information given here:
http://poe.perl.org/?POE_FAQ/How_do..._resource_leaks
Z
On 6/19/07, Matt S Trout <poe-perl-org@trout.me.uk> wrote:
>
> On Tue, Jun 19, 2007 at 03:58:12PM -0400, Zack Payton wrote:
> source
> known
> that
>
> "known issue" according to whom?
>
> If there's a bug it should be reported and fixed.
>
> Trying to find a replacement instead of fixing what's there is just silly
> ...
>
> --
> Matt S Trout Need help with your Catalyst or DBIx::Class
> project?
> Technical Director Want a managed development or deployment
> platform?
> Shadowcat Systems Ltd. Contact mst (at) shadowcatsystems.co.uk for a
> quote
> http://chainsawblues.vox.com/
> http://www.shadowcatsystems.co.uk/
>
| |
| Matt S Trout 2007-06-19, 7:27 pm |
| On Tue, Jun 19, 2007 at 03:58:12PM -0400, Zack Payton wrote:
> Hello all,
>
> I've been using EasyDBI for some time, and I just realized it was the source
> of some memory leaks... as I search the internet I find that it's a known
> issue. Doe!
> Can anyone recommend a cross platform replacement? Hopefully something that
> will work on Windows and Linux.
"known issue" according to whom?
If there's a bug it should be reported and fixed.
Trying to find a replacement instead of fixing what's there is just silly ...
--
Matt S Trout Need help with your Catalyst or DBIx::Class project?
Technical Director Want a managed development or deployment platform?
Shadowcat Systems Ltd. Contact mst (at) shadowcatsystems.co.uk for a quote
http://chainsawblues.vox.com/ http://www.shadowcatsystems.co.uk/
| |
| Matt S Trout 2007-06-20, 4:31 am |
| On Tue, Jun 19, 2007 at 04:30:39PM -0400, Zack Payton wrote:
> Correction:
>
> Known issue misreported:
> http://www.annocpan.org/~DSNOPEK/PO...MessageQueue.pm
>
> You're right it is silly, but timing is off the essence, and a replacement
> is more viable at this point. Perhaps you could offer some tips for
> tracking down memory leaks beyond the information given here:
> http://poe.perl.org/?POE_FAQ/How_do..._resource_leaks
A replacement isn't more viable since it's almost certainly your own code
leaking memory.
I'd recommend Devel::Leak and Devel::LeakTrace::Fast.
Quick thought: if you're doing lots of random SQL statements and you've told
EasyDBI to use prepare_cached then it's going to hang onto a -lot- of $sth
objects and you might find that periodically forcing it to disconnect is
the answer.
--
Matt S Trout Need help with your Catalyst or DBIx::Class project?
Technical Director Want a managed development or deployment platform?
Shadowcat Systems Ltd. Contact mst (at) shadowcatsystems.co.uk for a quote
http://chainsawblues.vox.com/ http://www.shadowcatsystems.co.uk/
| |
| Zack Payton 2007-06-20, 7:26 pm |
| Matt,
You were right, thanks man for the tips. It was an failure to shut down a
session combined with a cache issue. Setting no_cache also helped a lot.
Thank you,
Z
On 6/19/07, Matt S Trout <poe-perl-org@trout.me.uk> wrote:
>
> On Tue, Jun 19, 2007 at 04:30:39PM -0400, Zack Payton wrote:
> http://www.annocpan.org/~DSNOPEK/PO...MessageQueue.pm
> replacement
>
> A replacement isn't more viable since it's almost certainly your own code
> leaking memory.
>
> I'd recommend Devel::Leak and Devel::LeakTrace::Fast.
>
> Quick thought: if you're doing lots of random SQL statements and you've
> told
> EasyDBI to use prepare_cached then it's going to hang onto a -lot- of $sth
> objects and you might find that periodically forcing it to disconnect is
> the answer.
>
> --
> Matt S Trout Need help with your Catalyst or DBIx::Class
> project?
> Technical Director Want a managed development or deployment
> platform?
> Shadowcat Systems Ltd. Contact mst (at) shadowcatsystems.co.uk for a
> quote
> http://chainsawblues.vox.com/
> http://www.shadowcatsystems.co.uk/
>
| |
|
|
|
|
|