SVN is a life saver in the multi-developer project world.  Heck, even with just one developer we would recommend it.  The ability to organize code revisions is necessity.  Now mix in the CakePHP framework and we have some developers that chose everything perfect for development.

To start, I really think that many people don’t use SVN properly to organize their code.  I myself am one who was like this.  In the past, we only worked in Trunk.  Great, we had the ability to work on our own working copies of the repo, but beyond that, doing code pushes and managing larger revisions versus simple fixes/updates becomes hard.

(more…)

Loadsys creates a lot of larger web applications for clients that have many user types with many privileges.  The ACL tables out of the box, ACOS and AROS, do not contain indexes except for the PRIMARY KEY on id.

Since the ACL uses Binary Search Trees, a lot of complex queries take place with the left and right nodes.

So, let’s take a look at how one of the most intensive ACL queries acts with no changes made.

(more…)