Hi,
I used the script $LLIAPI.NodeUtil.ApplyPermsToSubNodes in my new module and have been seeing performance issues when it has a large number of sub-items to update in Livelink. More specifically it seems to lock the database tables.
Has anyone seen this before? Is there a workaround to use something else that would make it more efficient? I did think of the node crawler but I am concerned about missing out on database updates that the script runs in the background.
One thought I had is that the CAPI.ExecN (in the ApplyPermsToSubNodes script) runs the entire update as one transaction that is only commited when the entire set of inserts/updates/deletes is complete. Can someone shed some light on this?
Thanks,
Aruna