[OGDev] [OpenGuides-Dev] OG performance

[Dominic Hargreaves]

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.

-- 
Dominic Hargreaves | http://www.larted.org.uk/~dom/
PGP key 5178E2A5 from the.earth.li (keyserver,web,email)