Chris Winters <[EMAIL PROTECTED]> wrote:
> I'm not sure how you create your database handles (in a central
> location then passed around, or in each handler as you need it), but
> in MySQL (as with other databases) you can execute a 'use <dbname>' to
> start using a different database.
FWIW, MySQL is quite happy performing queries on foreign databases through
DBI; I've needed to do this to perform queries that span tables on
multiple databases. Not sure of the performance overhead, but if you fully
qualify your fields (as in db.table.field) it shouldn't matter what
database your handle is actually opened on.
Pete