Ok thanks AD, here is what I got from the Profiler.... I still can't understand which part to investigate and what eats up all the resources here:
http://www.eg-host.net/cache_grind_requests_controller.zip Sorry for pasting the Model relations the way I did... thought this will be less confusing as Model Names will never affect the speed. Anyway the Request Model has the following relations: var $hasOne = array("DraftMessage"); var $hasMany = array("TourFile","RequestsMeal","RequestsCruise","RequestPayment","RequestsHotel","RequestsThingstodo","RequestReminder","RequestsGroupMember","RequestsDomesticFlight","RequestsTransfer","RequestsInternationalFlight","RequestsTrainTicket","RequestRefusal","RequestReply"=>array("order"=>"RequestReply.id asc")); var $belongsTo = array( 'Department', 'Branch', 'Client', 'RequestStatus', 'Currency', 'Source' => array( 'className' => 'Source', 'foreignKey' => 'source_id' ), 'SubSource' => array( 'className' => 'Source', 'foreignKey' => 'sub_source_id'), 'Staff' => array( 'className' => 'Staff', 'foreignKey' => 'staff_id'), 'DelegatedTo' => array( 'className' => 'Staff', 'foreignKey' => 'delegated_to')); It is important to say that the system is not only slow at this controller... I am just maintaining the same example request throughout the discussion. The whole system is heavy, although non-db dependent ones work bit faster. Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en To unsubscribe, reply using "remove me" as the subject.
