Hmm...interesting. In our case we don't have permission_p in
the where clause, we're just getting a list of id's and
permission_p for each one. Example: we display on the
homepage a list of classes I am taking. We want to display a
little "admin" link to the administration page for each clas I am a
professor for. So we compute whether or not I have admin
privilege for each class. This can can maybe half a second per
row, bogging things down if I happen to be a professor for a
number of classes.
How long does an average permission check take on your
system?