Forum OpenACS Development: Re: improving permission queries

Collapse
Posted by Malte Sussdorff on
And I thought it was there all along. Thanks for tracking this down.

In my opinion this should be getting into the 5.3.1 release of OpenACS core, as I would say a speedup of permission queries by a factor of 10 translates into a bug in the previous version.

Collapse
Posted by Gustaf Neumann on
there are couple of indices already on the various permission related tables, but not that one. When the server is getting to its limits, db-queries that take under "sunshine conditions" 2ms will take sometimes 2 or more seconds. I would think that for most rather low traffic installations, this index does not matter. For us it did, so i reported it back.

It is not a bug, the functional behavior is exactly the same like before. Every trained oacs admin can feed the single line into her database. But be aware that the database upgrade script will barf on upgrading upgrade-5.3.0b1-5.3.0b2.sql
I found no simple and proven way to create indices conditionally on postgres and oracle.

-gustaf neumann
PS: the actual upgrade scripts were missing at the time of my original post two days ago.