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