Re: "Dynamic" database handles?

[prev] [thread] [next] [Date index for 2005/01/24]

Hey Jason,

> The other alternative to using pnotes is to have something like an ENV
> var that won't be corrupted across apache children and use that to key
> into a config module, returning already generated configs if they exist.
> That cuts out 99% of your inefficiencies.  Apache::DBI will be doing
> something similar for your actual database handles, so "reconnecting" is
> a pretty cheap operation.

This is more or less what my config module does behind the scenes - an
environment variable is set for each virtual host and the config is
keyed by this.  But my config module also does some other ugly (and
probably expensive) stuff behind the scenes when retrieving a
configuration variable.

Also I just did a test to find out exactly how frequently db_Main is
called.  On a Class::DBI-intensive page I have, db_Main was called more
than 600 times!  So tweaking db_Main does seem like the low-hanging
fruit of optimizations.

But I probably should actually profile things before getting too 
excited :)

(Side note:  600 calls to db_Main in a single request!  That means 600
queries, right?  Wow.)


Michael




--
Michael Graham <magog@xxxxxxxx.xxx>