diff options
| author | Stefan Winkler | 2011-12-15 11:22:24 +0000 |
|---|---|---|
| committer | Stefan Winkler | 2011-12-21 21:40:09 +0000 |
| commit | 5a9fccbe29334c7cc593deb7e27fb709d3a49e44 (patch) | |
| tree | 865f4fa939b6d6d090d9155d37f941169bad6369 | |
| parent | 841a3d4e5de551f3e993aecd7d694c3385b44ea8 (diff) | |
| download | cdo-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.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 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(); } |