diff options
| author | Stefan Winkler | 2011-12-15 11:22:24 +0000 |
|---|---|---|
| committer | Stefan Winkler | 2011-12-15 14:53:05 +0000 |
| commit | 0df2f722b0f09001607ff529c87dad81167ade0f (patch) | |
| tree | 6099edf106a0a55a623cf36829f7d8cc6eabce99 | |
| parent | 7fa0334aa96f6d2de08f5995feaf97099a869a48 (diff) | |
| download | cdo-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.java | 4 |
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(); } |