My understanding is that this enables CakePHP Models to identify details about your schema. By extracting this metadata, the models can be further exploited by ohter areas in cake, such as the helpers. The form helper, for example uses the metadata to automatically set size and limits on fields in the generated HTML.
As far as I'm aware, this information is cached, in tmp/models/*. This cache is used when not in debug mode. Hopefully someone else may be able to confirm or correct me if I'm wrong. Richard On Mon, Mar 16, 2009 at 12:35 PM, joshua <[email protected]> wrote: > 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 <[email protected]> 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 [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 -~----------~----~----~----~------~----~------~--~---
