I find there is a sql which will took >17ms everytime when the action needs authentication in ACL model. That means if I use ACL database model in my application , there will always be >17ms was taken. Can someone give an explanation of this?
//sql SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `acos` AS `Aco` LEFT JOIN `acos` AS `Aco0` ON (`Aco0`.`alias` = 'controllers') JOIN `acos` AS `Aco1` ON (`Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`rght` < `Aco0`.`rght` `Aco1`.`alias` = 'Users') LEFT JOIN `acos` AS `Aco2` ON (`Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`alias` = 'activity') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco2`.`lft` AND `Aco`.`rght` >= `Aco2`.`rght`)) ORDER BY `Aco`.`lft` DESC //end On Mon, Mar 16, 2009 at 8:22 PM, Joshua <josh...@gmail.com> wrote: > > As you can see, the 'describe' sql took (7+17+17) ms! Why they are > there? Can I disable it? > > > 1 DESCRIBE `aros` 7 7 7 > 2 DESCRIBE `acos` 7 7 17 > 3 DESCRIBE `aros_acos` 7 7 17 > > > -- Thanks Joshua --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---