Forum OpenACS Development: Re: OpenACS Permissions System - Performance Improvement Work

"Your comment that "analyze isn't really necessary for a test system" is false ... "

Mmmm...............False will bells on I think!

After running a vacuumdb with full and analyse (four times for good measure!) the standard query returns results for both 448 and -1 in approximately 1.2ms - which is great news.

The alternative query runs slightly slower now at just under 2ms for both tests which clearly demonstrates that the current method is best. Thank you for your help - sorry to soak up your precious time.

Now I can get on with working on the PM without worrying about permissions calls!

😊