Slower machine 1,000's of time faster??

[David Wynter]

I think that it is the MySQL setup that is causing this. On a separate much slower machine the query runs in seconds. It has this explain:

1, 'PRIMARY', 'ce1', 'index', 'PRIMARY,Cap_Chng_Market_idx', 'PRIMARY', 8, '', 194169, ''
1, 'PRIMARY', 'ce2', 'ref', 'PRIMARY,Cap_Chng_Market_idx', 'Cap_Chng_Market_idx', 9, 'securitymaster.ce1.Cap_Chng_Market_Lvl_Id', 24271, 'Using where; Using index'
2, 'UNION', 'ce3', 'index', 'PRIMARY,Div_Market_Lvl_idx', 'PRIMARY', 8, '', 194169, ''
2, 'UNION', 'ce4', 'ref', 'PRIMARY,Div_Market_Lvl_idx', 'Div_Market_Lvl_idx', 9, 'securitymaster.ce3.Div_Market_Lvl_Id', 1, 'Using where; Using index'
3, 'UNION', 'ce5', 'index', 'PRIMARY,Asset_Id_idx,Event_Type_idx', 'PRIMARY', 8, '', 194169, 'Using where'
3, 'UNION', 'ce6', 'ref', 'PRIMARY,Asset_Id_idx,Event_Type_idx', 'Asset_Id_idx', 9, 'securitymaster.ce5.ASSET_ID', 1, 'Using where'
4, 'UNION', 'ce7', 'ref', 'PRIMARY,Event_Type_idx', 'Event_Type_idx', 5, 'const', 767, 'Using where; Using temporary; Using filesort'
4, 'UNION', 'ce8', 'ref', 'PRIMARY,Event_Type_idx', 'Event_Type_idx', 5, 'const', 767, 'Using where'
, 'UNION RESULT', '<union1,2,3,4>', 'ALL', '', '', , '', , ''

i.e it is that same as the faster machine where the query takes 30 minutes to run? I cannot explain the difference

David