Very Simple MySQL Inner Join Extremely Slow
I ended up moving the tables back to InnoDB and then increasing the innodb_buffer_pool_size to 8G.  It's still not sub 1 second like our MS SQL Server, but it is finishing in under 5 seconds, so a huge step in the right direction.