Re: speed of cross-database queries

2003-09-25 Thread Jeremy Zawodny
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 t

speed of cross-database queries

2003-09-25 Thread Kevin
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 invalida