On Thu, Sep 25, 2003 at 11:46:49AM -0700, Kevin wrote: > 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"
They're no slower than cross-table queries in the same database. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 11 days, processed 428,759,895 queries (420/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]