ACL Table Optimization
Posted on | September 10, 2008 | No Comments
The begin of all web application development is the identification of entities found in the problem domain aka the application. When the models, controllers and views are baked. It is time for the ACL and Auth to fall in place. Found this ACL table optimization tip from my search of best practises for Cakephp
Creating index for the aros, acos and aros_acos tables will speed up the look up time. These are the SQL statements that I have executed.
ALTER TABLE `aros` ADD INDEX `user` ( `model` ( 255 ) , `foreign_key` ) ;# Affected rows: 4
ALTER TABLE `acos` ADD INDEX `alias` ( `alias` ( 255 ) ) ;# Affected rows: 39
ALTER TABLE `aros_acos` ADD INDEX `relation` ( `aro_id` , `aco_id` ) ;# Affected rows: 11
This tip comes from http://myeasyscripts.com/loudbaking/acl-tables-optimization-for-cakephp-12xx/
