optimize query -- need help

[Mohammed Munazir Ul Hasan]

Hi,

We are using MySQL Cluster 7.2.1 dev milestone with 4 data nodes (20 GB Each with 4x4 CPUs).

This query takes 159.45 seconds on Cluster(NDB Engine) where as on standalone it's takes 3.39 seconds on MyISAM Engine.


Select A.* , B.* , C.* ,SUM(D.Length_Of_Training*D.Training_Fee) as Training_Fee
, SUM(D.Length_Of_Training*D.Total_Training_Salary) as Total_Training_Salary
, SUM(D.Length_Of_Employment*D.Total_Employment_Salary) as Total_Employment_Salary
FROM cbp_pcetcontract A , cbp_contractdeliverable D, cbp_contract E , cbp_position C , cbp_bpprofile B
where D.Contract_ID = E.Contract_ID
and A.ContractDeliverableId = D.CD_Id
and A.PositionId = C.Position_ID
and B.BP_Id = A.BP_Id

Any body can help me out to optimize this query with respect to NDB Engine.

If need any other details please update me.

Thanks
Mohammed Munazir



Edited 2 time(s). Last edit at 10/15/2011 04:58AM by Mohammed Munazir Ul Hasan.