Skip to main content
aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorStefan Winkler2011-12-15 06:22:24 -0500
committerStefan Winkler2011-12-21 16:40:09 -0500
commit5a9fccbe29334c7cc593deb7e27fb709d3a49e44 (patch)
tree865f4fa939b6d6d090d9155d37f941169bad6369
parent841a3d4e5de551f3e993aecd7d694c3385b44ea8 (diff)
downloadcdo-5a9fccbe29334c7cc593deb7e27fb709d3a49e44.tar.gz
cdo-5a9fccbe29334c7cc593deb7e27fb709d3a49e44.tar.xz
cdo-5a9fccbe29334c7cc593deb7e27fb709d3a49e44.zip
[367356] [DB] Reduce amount of update statements for non-audit mode
https://bugs.eclipse.org/bugs/show_bug.cgi?id=367356 replace <= and >= with BETWEEN operator
-rw-r--r--plugins/org.eclipse.emf.cdo.server.db/src/org/eclipse/emf/cdo/server/internal/db/mapping/horizontal/NonAuditListTableMapping.java4
1 files changed, 1 insertions, 3 deletions
diff --git a/plugins/org.eclipse.emf.cdo.server.db/src/org/eclipse/emf/cdo/server/internal/db/mapping/horizontal/NonAuditListTableMapping.java b/plugins/org.eclipse.emf.cdo.server.db/src/org/eclipse/emf/cdo/server/internal/db/mapping/horizontal/NonAuditListTableMapping.java
index 6c84daf20d..1398add603 100644
--- a/plugins/org.eclipse.emf.cdo.server.db/src/org/eclipse/emf/cdo/server/internal/db/mapping/horizontal/NonAuditListTableMapping.java
+++ b/plugins/org.eclipse.emf.cdo.server.db/src/org/eclipse/emf/cdo/server/internal/db/mapping/horizontal/NonAuditListTableMapping.java
@@ -166,9 +166,7 @@ public class NonAuditListTableMapping extends AbstractListTableMapping implement
builder.append(CDODBSchema.LIST_REVISION_ID);
builder.append("=? AND "); //$NON-NLS-1$
builder.append(CDODBSchema.LIST_IDX);
- builder.append(" >= ? AND "); //$NON-NLS-1$
- builder.append(CDODBSchema.LIST_IDX);
- builder.append(" <= ?"); //$NON-NLS-1$
+ builder.append(" BETWEEN ? AND ?"); //$NON-NLS-1$
sqlMassUpdateIndex = builder.toString();
}

Back to the top