[rt-users] UseSQLForACLChecks / CurrentUserCanSee

[ktm at rice.edu]

Dear RT community,

I have been testing the option UseSQLForACLChecks which is based on the
function CurrentUserCanSee and the initial testing is disappointing. Here
are 3 representative front page loads with and without SQL-checks enabled:

with-SQL: 16s, 13.8s, 14.5s --- 14.7s average
no-SQL: 2.3s, 0.99s, 0.97s --- 1.42s average

That is a 10x slowdown and it does not get any better with reloads. In
some of the messages on the mailing list, it is mentioned that the performance
is "not bad" for some setups. Is there a reference setup that is defined that
produces these "not bad" timings? Alternatively, does anyone have a setup
that is working well or that has an appropriate cache layer setup?

Regards,
Ken