Thanks for the tip Perrin. Now I can move forward. :)
Perrin Harkins wrote:
Foo Ji-Haw wrote:
Can anyone recommend an alternative solution to my problem?
Nowhere near as fast, but MLDBM::Sync is solid and well-tested on
Windows.
- Perrin
On Mar 20, 2006, at 5:48 PM, Perrin Harkins wrote:
Here's my guess -- are you calling you DBI->connect() on every
request?
yep.
If this is all making you annoyed with Apache::DBI, just make your own
cleanup handler that does a rollback. It's easy to do, as long as you
have a simple way to g
On Mon, 2006-03-20 at 17:29 -0500, Jonathan Vanasco wrote:
> I'm not even seeing an explicit rollback on the good handle, which
> makes me think something odd happened on my config
Here's my guess -- are you calling you DBI->connect() on every request?
If you don't, Apache::DBI won't work. I'v
On Mar 20, 2006, at 3:50 PM, Perrin Harkins wrote:
It only does that if you connect with AutoCommit off.
my connect args are
{ RaiseError => 0, AutoCommit => 0 , TraceLevel => 1 }
Can you give an example of an invalid SQL command, and what was "bad"
about the cached handle on the nex
On Mon, 2006-03-20 at 15:22 -0500, Jonathan Vanasco wrote:
> I did a bunch of tracing this morning it seems that apache::dbi isn't
> always issuing the rollback at cleanup
It only does that if you connect with AutoCommit off.
> if there's an invalid sql command executed in my transaction though
a) i fixed the 'message ' errors - they were indeed from an
accidentally preforked handle. i'll try to make a note or something
for apache docs this evening.
b)
I did a bunch of tracing this morning it seems that apache::dbi isn't
always issuing the rollback at cleanup
I set a trace
Title: Memory Leak when using PerlAccessHandler (WIN32/Apache2/PERL5.8.3).
I'm experiencing a memory leak when using the PerlAccessHandler handler. The leak is very slow but certainly exists. I've dumbed down the handler to its simplest form:
package Apache2::MYHANDLER;
use strict;
use Ap
Foo Ji-Haw wrote:
Can anyone recommend an alternative solution to my problem?
Nowhere near as fast, but MLDBM::Sync is solid and well-tested on Windows.
- Perrin
