I realized after posting that the post I referenced assumes MySQL, but the idea of indexing is relative nonetheless.
On Tuesday, April 17, 2012 8:20:05 AM UTC-7, jeremyharris wrote: > > It's quite possible you're just missing indexes[1], which would be a huge > performance problem. Also, make sure the engine is innodb. > > 1: > http://blog.loadsys.com/2008/03/19/cakephp-12-tuning-the-acl-via-mysql/ > > On Tuesday, April 17, 2012 6:00:05 AM UTC-7, Farah wrote: >> >> I'm not expert in CakePHP, but its very clear that the ACL is slow if my >> tables database acos, aros and aros_acos over thousand rows. >> >> Just a simple $this->Acl->check() runs over 500 queries and its clear >> that its not the acl generate that, it uses the Tree behavior to find the >> specific permission. >> >> 1. I'm not using database session. >> 2. There are many articles on the internet talking about that, and I'm >> not blaming, I'm just trying to figure out how fast my app can be. >> >> The articles >> >> 1. http://www.visuallizard.com/blog/2009/10/19/241 >> 2. >> http://www.mainelydesign.com/blog/view/speeding-up-cakephp-acl-component >> 3. >> http://phpknight.com/cakephp-acl-controlled-application-slow-performance-problem/ >> >> >> I'll create a component and helper to make this faster as soon as >> possible and I'll post it here. >> >> Thanks for your attention =) >> >> >> On Tuesday, April 17, 2012 9:13:21 AM UTC-3, stork wrote: >>> >>> 1. Do you store sessions in database? If yes, is it the same database as >>> the one with application data? If yes, why? And why not use other >>> (memcache) storage for sessions? >>> >>> 2. Stop blaming core code for slowness, until you'll be able to write >>> short example NOT using your own classes like SessionAcl etc in it, >>> especially not after your example code "snippet" above. I do have advanced >>> imagination and I'm more then just a bit scared of what and how does your >>> other custom code, used in your last loop over $acoes, where I even don't >>> know what $recursive you used and how many associations are queried along. >>> >>> Set up clean CakePHP installation, connect it to the very same database >>> like your ACL uses, and run some test code related to your doubts WITHOUT >>> your own code. >>> >> >> On Tuesday, April 17, 2012 9:13:21 AM UTC-3, stork wrote: >>> >>> 1. Do you store sessions in database? If yes, is it the same database as >>> the one with application data? If yes, why? And why not use other >>> (memcache) storage for sessions? >>> >>> 2. Stop blaming core code for slowness, until you'll be able to write >>> short example NOT using your own classes like SessionAcl etc in it, >>> especially not after your example code "snippet" above. I do have advanced >>> imagination and I'm more then just a bit scared of what and how does your >>> other custom code, used in your last loop over $acoes, where I even don't >>> know what $recursive you used and how many associations are queried along. >>> >>> Set up clean CakePHP installation, connect it to the very same database >>> like your ACL uses, and run some test code related to your doubts WITHOUT >>> your own code. >>> >> >> On Tuesday, April 17, 2012 9:13:21 AM UTC-3, stork wrote: >>> >>> 1. Do you store sessions in database? If yes, is it the same database as >>> the one with application data? If yes, why? And why not use other >>> (memcache) storage for sessions? >>> >>> 2. Stop blaming core code for slowness, until you'll be able to write >>> short example NOT using your own classes like SessionAcl etc in it, >>> especially not after your example code "snippet" above. I do have advanced >>> imagination and I'm more then just a bit scared of what and how does your >>> other custom code, used in your last loop over $acoes, where I even don't >>> know what $recursive you used and how many associations are queried along. >>> >>> Set up clean CakePHP installation, connect it to the very same database >>> like your ACL uses, and run some test code related to your doubts WITHOUT >>> your own code. >>> >> >> On Tuesday, April 17, 2012 9:13:21 AM UTC-3, stork wrote: >>> >>> 1. Do you store sessions in database? If yes, is it the same database as >>> the one with application data? If yes, why? And why not use other >>> (memcache) storage for sessions? >>> >>> 2. Stop blaming core code for slowness, until you'll be able to write >>> short example NOT using your own classes like SessionAcl etc in it, >>> especially not after your example code "snippet" above. I do have advanced >>> imagination and I'm more then just a bit scared of what and how does your >>> other custom code, used in your last loop over $acoes, where I even don't >>> know what $recursive you used and how many associations are queried along. >>> >>> Set up clean CakePHP installation, connect it to the very same database >>> like your ACL uses, and run some test code related to your doubts WITHOUT >>> your own code. >>> >> -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. 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