logo
Toggle navigation
Begin main navigation
About
Projects
Download
Documentation
Wiki
Forums
Log In
Go!
OpenACS – The Toolkit for Online Communities
:
Forums
:
OpenACS Q&A
:
How to batch update security_inherit_p efficiently?
: One Message
Begin main content
Forum OpenACS Q&A: Re: How to batch update security_inherit_p efficiently?
Search:
Back to OpenACS Q&A
2
:
Re: How to batch update security_inherit_p efficiently?
(response to
1
)
Posted by
Don Baccus
on
01/25/03 11:12 PM
Get rid of the loop! Can you create a select statement that will find all the objects for you?
Something like
update foo set bar = 0 where pkey in (select pkey from foo where ...)
should be much faster than doing 80,000 separate update statements.
Back to OpenACS Q&A