Skip to main content
aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorStefan Winkler2011-12-15 06:22:24 -0500
committerStefan Winkler2011-12-15 09:53:05 -0500
commit0df2f722b0f09001607ff529c87dad81167ade0f (patch)
tree6099edf106a0a55a623cf36829f7d8cc6eabce99
parent7fa0334aa96f6d2de08f5995feaf97099a869a48 (diff)
downloadcdo-0df2f722b0f09001607ff529c87dad81167ade0f.tar.gz
cdo-0df2f722b0f09001607ff529c87dad81167ade0f.tar.xz
cdo-0df2f722b0f09001607ff529c87dad81167ade0f.zip
[366686] [DB] Reduce amount of update statements for non-audit mode
https://bugs.eclipse.org/bugs/show_bug.cgi?id=366686 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 26c74017ed..6f732cf928 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
@@ -165,9 +165,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