Forum OpenACS Development: Re: Simplification of Assessment

Collapse
Posted by Dave Bauer on
I wonder if its this code in the insert rule

"update cr_dummy set val = (
select content_revision__new("

cr_dummy is a one row table that is used to make the rule work in postgresql.

If its called in a transaction would it lock that table and not allow another update to that table for a new revision until the first transaction is done?

If you do an entire assessment anwer insert in one transaction and there are many questions, it could take several seconds or more to finish the transaction.

Maybe Don can comment on this.