Both times seem a bit long, even if you database has millions of rows.
Can you post and explain of your query? That they are in different
databases should have minimal effect on your query.
Brent
On Oct 3, 2008, at 12:14 PM, mos wrote:
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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]