Re: ACL very slow

2012-04-17 Thread Farah
Yes, all fields has index On Tuesday, April 17, 2012 12:21:36 PM UTC-3, jeremyharris wrote: > > 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 qu

Re: ACL very slow

2012-04-17 Thread Farah
Thanks for the reply! On Tuesday, April 17, 2012 11:16:49 AM UTC-3, stork wrote: > > Also, check out these projects > http://plugins.cakephp.org/packages?query=acl > if you do not need wheel with some special shape. > On Tuesday, April 17, 2012 11:16:49 AM UTC-3, stork wrote: > > Also, check out

Re: ACL very slow

2012-04-17 Thread jeremyharris
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 su

Re: ACL very slow

2012-04-17 Thread jeremyharris
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 CakePH

Re: ACL very slow

2012-04-17 Thread stork
Also, check out these projects http://plugins.cakephp.org/packages?query=acl if you do not need wheel with some special shape. -- 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 wit

Re: ACL very slow

2012-04-17 Thread stork
> 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/ > 1. 2009/10 2. 2010/05 3. 2010/06 Better use current stable CakePHP r

Re: ACL very slow

2012-04-17 Thread Farah
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 permissi

Re: ACL very slow

2012-04-17 Thread stork
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 Session

Re: ACL very slow

2012-04-17 Thread Farah
Ok, I'm sorry stork, but I if I just try put in the session all permissions of the controller: $acoes = $this->Acao->find("all", array("conditions" => array("Controller.alias" => $controller))); foreach ($acoes as $key => $acao) { if (!$this->Session->check("Auth.Perm

Re: ACL very slow

2012-04-17 Thread stork
> Any one can help me with this ? Not me, sorry. This is example, how should NOT look code of CakePHP application, controller should be as slim as possible. -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://as