Forum OpenACS Q&A: Re: How to batch update security_inherit_p efficiently?

Collapse
Posted by Don Baccus on
It will undoubtably still run slow because changing security_inherit_p to 'f' will modify a bunch of rows for each object in the table that maps an object to its context parent.

Check the triggers in, I believe, acs-objects-create.sql.

You may be able to drop the trigger then write a PL/SQL proc to create the map afterward.

But writing the proc may take longer than the day you'll save ...

maybe if you're lucky the massive update approach will only take 21.5 hours!