On Tue, Jun 05, 2007 at 08:01:37AM -0400, Christopher Schmidt wrote:
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...
We ought to be keeping database handles around and reusing them, and if we're not, and not destroying them, than this is obviously going to cause the number of database connections to spiral. We need to look into the code to correct this; it shouldn't be hard. One for this weekend maybe.
Dominic.