Hello, I'm doing this some in my application, and was wondering if anyone had any ideas about the efficiency of cross-database queries:
"Select * from db1.poems left join db2.users on poems.mid = users.mid" My runtime variables do show 319 'change db' queries - but I don't know if that invalidates cached tables, indexes, or if its not a big deal at all... Ciao, Kevin Watt Community Manager, Allpoetry.com How do really small people call each other ? On Microphones How do you fix a broken chimp? With a monkey wrench -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
