Well if the content repository is this broken, we should fix it, or remove it from OpenACS.
I think perhaps the way it is being used may be the issue, and it probably can be improved.
I still don't understand why inserts would lock a table. This doesn't seem to be necessary and if its happening, something is likely broken that can be fixed.