All,
I have a query that is inner joined with another table based on country codes
Select distinct Name.* from Name inner join Location on Location.key =
Name.key and Location.cc in ('<list of countries here>');
The problem is when I have more than 2 country codes, the query takes forever...
When I show processlist, it says converting HEAP to MyISAM ( this takes over an hour
)...
I've tried bumping up max_heap_table_size to 128M and tmp_table_size to 128M, but that
only
seems to delay the converting HEAP to MyISAM message....
Name contains about 3 million records and Location contains about 1.5 million records.
Using MySQL 4.0.14-pro
Thanks,
Cory Twibell
Lockheed Martin Space Systems Company
Electronic Combat Development Systems
[EMAIL PROTECTED]
(303) 971-3184
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
