List.add(int,Object) is inefficient in default mappings
-------------------------------------------------------
Key: OPENJPA-411
URL: https://issues.apache.org/jira/browse/OPENJPA-411
Project: OpenJPA
Issue Type: Improvement
Affects Versions: 1.0.0, 0.9.7, 0.9.6, 0.9.0
Reporter: Patrick Linskey
Fix For: 1.1.0
>From [EMAIL PROTECTED]:
When List.add(index, object) is being used
OpenJPA sends the following sql statement, so the order of the elements can
be built up from scratch:
"Delete from RELATION_TABLE where ID = ?"
In ms sql server this causes an exclusive lock on the entire table which of
course easily introduces blocking issues (long running transactions having a
shared lock or other client who like to insert objects in their list as
well).
List.add(Object) does not have this behaviour so when adding objects to the
end of the list it is always better to use this method.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
