On Tue, Jun 05, 2007 at 12:49:33PM +0100, Bob Walker wrote:
On Tue, 5 Jun 2007, Christopher Schmidt wrote:
I run the Open Guide to Boston under mod_perl without problems. I believe that I brought all the patches I made to the code back into line with the main trunk, so I am not aware of any reason that the code should not be mod_perl friendly.
is your use of memcached hiding possible connection exhaustion issues? would your memcached stuff help with london's problem?
Even when memcached is in place, I still connect to the database, even when all the data is loaded from cache. (That's a bug, but not one I care about). However, I have my database set up to allow max connections of twice the number of apache threads I have, and OpenGuides only connects once per page as far as I remember -- I've done some looking at this -- so I don't think it'd be a problem...
However, I'm using MySQL, and I know you're not. It's possible that the W::T Store module for Postgres doesn't do closing and MySQL does?
I can't tell whether memcached would help: it would depend on whether there is free memory on the box, and whether the load is from getting the data or from styling it. In general, the latter is generally true, but someone with access to the box might be better suited to determine that.
In general, mod_perl has helped much much much more with performance than memcached has, especially on the single-node case (rather than category listings or the ilke).
REgards,