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…)