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
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