Why are joins between tables in dif db so slow?

[mos]

I have two indexed MyISAM tables, each in a separate database. If I do a 
left join on the two tables, it takes 2 minutes to return the 5,000 rows. 
The same join on similar tables in the same database would take 5-10 
seconds. Both databases are on the same drive. So why is it 10x slower when 
the other table is in another database?

TIA
Mike


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]