Re: ACL controlled and slow performance

2010-02-19 Thread cakeFreak
Do you mean you specify InnoDB actions on delete etc? Dan On 15 Feb, 13:57, Jon Bennett wrote: > Hi Daniel, > > > Just a question: why did you opt for InnoDB tables rather than MyISAM? > > Always use InnoDB for data integrity. > > J > > -- > jon bennett -www.jben.net- blog.jben.net Check out th

Re: ACL controlled and slow performance

2010-02-15 Thread Jon Bennett
Hi Daniel, > Just a question: why did you opt for InnoDB tables rather than MyISAM? Always use InnoDB for data integrity. J -- jon bennett - www.jben.net - blog.jben.net Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You rec

Re: ACL controlled and slow performance

2010-02-13 Thread cakeFreak
by the way, after adding the indexes the ARO query takes 1 ms vs 5502 ms the ACO query takes 249 ms vs 628 ms Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Grou

Re: ACL controlled and slow performance

2010-02-13 Thread cakeFreak
Hey Jon, you are my MySQL performance GURU!!! ;o) Your solution of indexes worked great!! Just a question: why did you opt for InnoDB tables rather than MyISAM? Cheers Daniel Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You

Re: ACL controlled and slow performance

2010-02-13 Thread Jon Bennett
> Any clue on how to speed up things? Try optimising your db tables by adding some indexes, I have http://pastie.org/823086 hth Jon -- jon bennett - www.jben.net - blog.jben.net Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

Re: ACL controlled and slow performance

2010-02-13 Thread cakeFreak
by the way I use cakePHP 1.2.6 Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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.c

ACL controlled and slow performance

2010-02-13 Thread cakeFreak
Hey guys, I'm using ACL to control my application. I use it in the flavour of ACL "controlled" My user model $actsAs = array('Acl' => array('requester')); When I was building the application with 10 users and 5 groups everything was working fine. Every user belongsTo a group. I then inserted 1