Leo Lapworth wrote:
Put all your virtual hosts in one database, just start the table names
differently
so instead of <virtual_db>.tablename have application_db.<virtual>_tablename
This way apache only have to connect to one database.
There may be all sorts of reasons you don't want to do this - and from a
design point of view
it's a bit messy - but it would solve your issue.
True, that would work, but after a schema reaches a certain number of tables
things do start to degrade.
--
--------------------------------------------------------------------------
"Love is not the one you can picture yourself marrying,
but the one you can't picture the rest of your life without."
"It takes a minute to have a crush on someone, an hour to like someone,
and a day to love someone, but it takes a lifetime to forget someone..."
Philip M. Gollucci ([EMAIL PROTECTED]) 301.254.5198
Consultant / http://p6m7g8.net/Resume/resume.shtml
Senior Software Engineer - TicketMaster - http://ticketmaster.com
