Re: Slow Page Load due to 100's of ACL Queries

2010-08-25 Thread Jon Bennett
When a user is logged in, there are 100's of queries that are run against the database.  They come from a $this-Aro-Permission-find call in /cake/libs/controller/api-check(). The function, and corresponding DB calls, are executed once per row in the AROS table.  There are 1374 items in that

Re: Slow Page Load due to 100's of ACL Queries

2010-08-25 Thread Jon Bennett
When a user is logged in, there are 100's of queries that are run against the database.  They come from a $this-Aro-Permission-find call in /cake/libs/controller/api-check(). The function, and corresponding DB calls, are executed once per row in the AROS table.  There are 1374 items in that

Re: Slow Page Load due to 100's of ACL Queries

2010-08-25 Thread miller
It is version 1.2.4.8284. On Aug 25, 6:41 am, Jon Bennett jmbenn...@gmail.com wrote: When a user is logged in, there are 100's of queries that are run against the database.  They come from a $this-Aro-Permission-find call in /cake/libs/controller/api-check(). The function, and

Re: Slow Page Load due to 100's of ACL Queries

2010-08-25 Thread miller
Our authentication setup is simple. We have three groups: User, Supplier, Admin. Why would we need a record per user/admin/supplier in the Aros table? -mike On Aug 25, 6:41 am, Jon Bennett jmbenn...@gmail.com wrote: When a user is logged in, there are 100's of queries that are run against

Re: Slow Page Load due to 100's of ACL Queries

2010-08-25 Thread Jon Bennett
Our authentication setup is simple.  We have three groups: User, Supplier, Admin.  Why would we need a record per user/admin/supplier in the Aros table? It _could_ be the previous developer/team wanted more granular permissions than just group level, which is why you have a record per user