BerkeleyDB as a cache backend

2005-06-24 Thread Arshavir Grigorian
Hello list, I coded a caching system using BerkeleyDB::Hash as the backend. It was working fine until the database file became fairly large (850M). At some point the performance degraded and the web server process accessing the database started hanging. Someone suggested locking issues being t

Re: [UPGRADE]: Apache::DBI 0.96 for mod_perl 2.0 RC5

2005-06-24 Thread Kevin A. McGrail
At the very worst, if you are using the AuthDBI portion of ApacheDBI, 0.94 is worthless with mp2: Fri Jun 24 18:01:08 2005] [error] Can't locate Apache/Const.pm in @INC (@INC contains: /htdocs/gamma.thoughtworthy.com/html/lib /usr/local/lib/perl5/5.8.6/i686-linux /usr/local/lib/perl5/5.8.6 /usr/lo

Re: [UPGRADE]: Apache::DBI 0.96 for mod_perl 2.0 RC5

2005-06-24 Thread Jan Eden
Dan Sully wrote on 24.06.2005: >* Jan Eden shaped the electrons to say... > >>>Ask - Can this version be released to CPAN? >>> >>>Apache::DBI as shipped from CPAN is completely useless on MP2. >>> >> >>It is not. With the help of this list, I have been able to get it up > >Exactly. _With the help

Re: [UPGRADE]: Apache::DBI 0.96 for mod_perl 2.0 RC5

2005-06-24 Thread Dan Sully
* Jan Eden shaped the electrons to say... Ask - Can this version be released to CPAN? Apache::DBI as shipped from CPAN is completely useless on MP2. It is not. With the help of this list, I have been able to get it up Exactly. _With the help of this list_. One shouldn't need that. One sho

Re: [UPGRADE]: Apache::DBI 0.96 for mod_perl 2.0 RC5

2005-06-24 Thread Jan Eden
Dan Sully wrote on 23.06.2005: >* Philip M. Gollucci shaped the electrons to say... > >>http://p6m7g8.net/Apache-DBI-0.96.tar.gz was supposed to be >>http://p6m7g8.net/Apache-DBI/Apache-DBI-0.96.tar.gz >> >>I symlinked it in my site so both should be valid now. > >Ask - Can this version be release

Re: [mp2] A better way to set the Expire header

2005-06-24 Thread Mike Cardwell
* on the Thu, Jun 23, 2005 at 07:43:08AM -0400, Geoffrey Young wrote: > intelligently worrying about the browser cache will help your performance a > great deal. there's an entire section in the perl.apache.org docs about it. This is the logic I use. It may help someone. Where $cache is the num

Re: Constants Coexistence

2005-06-24 Thread Kevin A. McGrail
Here's a new patch against Philip's Apache::DBI v0.96 that includes a patch per the constants coexistence notes that makes the program work in MP1 and 2 without any warnings because of the constants. I believe that this Apache::DBI works now quite well under mp1 and mp2. However, I would like to

Re: Basic Authentication & logout

2005-06-24 Thread Dan Wilga
At 5:15 PM +0200 6/22/05, Andrea Palmeri wrote: I invalidate the user authencation and ask credentials once again, but I would like to just to invalidate the user authencation whitout prompting the user for credentials. Can't be done with basic auth. They will always get the "Authentication f

Re: Apache2 Testing with AuthDBI 0.96 with SHA1/MD5 Patch

2005-06-24 Thread Kevin A. McGrail
Thanks Philip & Frank: I can now confirm that AuthDBI 0.96 from Philip with my patches for Authentication seems to function as expected under both mp1.29 and mp2.0.1. I can also comment that I've emailed Ask as well about where to submit patches and not gotten a response. The version on CPAN has

Re: Apache::DBI and mod_perl

2005-06-24 Thread Jan Eden
Octavian Rasnita wrote on 24.06.2005: >As far as I know, the scope of Apache::DBI is to keep a permanent >connection with the database, but if the script disconnects after >each request, why using Apache::DBI? Apache::DBI overrides the DBI disconnect method, effectively keeping the connection al

Re: Apache::DBI and mod_perl

2005-06-24 Thread Octavian Rasnita
>So the recommendation is to not use Apache::DBI? > That sounds reasonable at this point. I was just wondering why Apache::DBI is effectively slowing down delivery in this setup where a lot of DB requests are involved. Is it because my scripts still contain a $dbh->disconnect() and overriding thi

Re: Apache::DBI and mod_perl

2005-06-24 Thread Jan Eden
Sean Davis wrote on 24.06.2005: >>After going through all this, I did an ApacheBench with/without >>Apache::DBI being used (1000 requests, 10 concurrent), and it >>turned out that Apache::DBI is actually slowing down delivery from >>13 requests/second to 7.78 (on my local test machine). > >Were an

Re: Apache::DBI and mod_perl

2005-06-24 Thread Octavian Rasnita
From: "Jan Eden" <[EMAIL PROTECTED]> After going through all this, I did an ApacheBench with/without Apache::DBI being used (1000 requests, 10 concurrent), and it turned out that Apache::DBI is actually slowing down delivery from 13 requests/second to 7.78 (on my local test machine). Oh my. --

Re: Apache::DBI and mod_perl

2005-06-24 Thread Sean Davis
On Jun 24, 2005, at 5:43 AM, Jan Eden wrote: Perrin Harkins wrote on 24.06.2005: On Fri, 2005-06-24 at 10:02 +0200, Jan Eden wrote: What is the overload message supposed to tell me? That you called disconnect but Apache::DBI prevented the handle from being disconnected. The "overload" mes

Re: Apache::DBI and mod_perl

2005-06-24 Thread Jan Eden
Perrin Harkins wrote on 24.06.2005: >On Fri, 2005-06-24 at 10:02 +0200, Jan Eden wrote: >>What is the overload message supposed to tell me? > >That you called disconnect but Apache::DBI prevented the handle from >being disconnected. > >The "overload" message is just poorly worded. It should proba

Re: Apache::DBI and mod_perl

2005-06-24 Thread Perrin Harkins
On Fri, 2005-06-24 at 10:02 +0200, Jan Eden wrote: > What is the overload message supposed to tell me? That you called disconnect but Apache::DBI prevented the handle from being disconnected. The "overload" message is just poorly worded. It should probably say "overridden" or something instead.

Re: Apache::DBI and mod_perl

2005-06-24 Thread Jan Eden
Philippe M. Chiasson wrote on 23.06.2005: >Perrin Harkins wrote: >>On Thu, 2005-06-23 at 11:29 +0200, Jan Eden wrote: >> >>>Everything works - but how can I know if Apache::DBI really keeps >>>my database connection alive? >> >>Turn on the debugging for Apache::DBI and check your error_log. >>See

Re: Switch and mod_perl

2005-06-24 Thread Jan Eden
Dorian Taylor wrote on 24.06.2005: >On Thu, Jun 23, 2005 at 03:19:22PM -0400, Perrin Harkins wrote: >> On Thu, 2005-06-23 at 10:46 +0200, Jan Eden wrote: >> > could it be that mod_perl doesn't play nice with the Switch module? >> >> Isn't it a source filter? Those don't work with mod_perl. >> >