openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Patrick Linskey (JIRA)" <j...@apache.org>
Subject [jira] Created: (OPENJPA-411) List.add(int,Object) is inefficient in default mappings
Date Mon, 22 Oct 2007 21:34:50 GMT
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 users@openjpa.apache.org:

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.


Mime
View raw message