MySQL Forums
Forum List  »  Optimizer & Parser

optimize query -- need help
Posted by: Mohammed Munazir Ul Hasan
Date: October 15, 2011 04:44AM


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.

Mohammed Munazir

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

Options: ReplyQuote

Written By
optimize query -- need help
October 15, 2011 04:44AM
October 16, 2011 10:58AM
October 18, 2011 10:42PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.