jamie - 2:06 pm on Feb 18, 2011 (gmt 0)
we are often doing the same, but instead of opening multiple connections, i only open one database connection then reference the other databases in the query. e.g.
SELECT field FROM database1.table1
SELECT field FROM database2.table1
the mysql user must have select permissions on each database.
tbh i am not actually sure whether this will improve performance though.