Thanks, for dma table, my source is as follows:
Code:
`dmacode` int(10) unsigned NOT NULL auto_increment,
`zipcode` int(5) unsigned zerofill NOT NULL default '00000',
`rank` tinyint(2) unsigned zerofill NOT NULL default '00',
`dmaname_clean` varchar(250) NOT NULL default '',
PRIMARY KEY (`dmacode`)
for erc_venue table my source is:
Code:
`venueid` int(6) unsigned NOT NULL auto_increment,
`venuetitle` varchar(30) NOT NULL default '',
`venueaddy` varchar(50) default NULL,
`venuecitystate` varchar(50) default NULL,
`venuezipcode` int(5) unsigned zerofill NOT NULL default '00000',
`venuecountry` varchar(20) default 'USA',
`venueurl` varchar(80) default NULL,
`venuephone` varchar(12) default NULL,
PRIMARY KEY (`venueid`)
and the explain thingie is as follows:
Code:
SELECT erc_venue.*, dma.*
FROM erc_venue
LEFT JOIN dma ON dma.zipcode = erc_venue.venuezipcode
ORDER BY erc_venue.venuetitle
LIMIT 0, 12
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE erc_venue ALL 98 Using temporary; Using filesort
1 SIMPLE dma ALL 45534
Time Before: 0.27991 seconds
Time After: 7.76009 seconds
Time Taken: 7.48018 seconds
Thanks!