MySQL Forums
Forum List  »  Optimizer & Parser

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

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
optimize query -- need help
1853
October 15, 2011 04:44AM
745
October 16, 2011 10:58AM
737
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.