Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 367356

Summary:	[DB] Reduce amount of update statements for non-audit mode
Product:	[Modeling] EMF	Reporter:	Eike Stepper <stepper>
Component:	cdo.db	Assignee:	Stefan Winkler <stefan>
Status:	CLOSED FIXED	QA Contact:	Eike Stepper <stepper>
Severity:	enhancement
Priority:	P3	Flags:	stepper: review+
Version:	4.0
Target Milestone:	---
Hardware:	All
OS:	All
Whiteboard:
Bug Depends on:
Bug Blocks:	272475

Description Eike Stepper

2011-12-21 12:18:21 EST

Cloned from: 366686: [DB] Reduce amount of update statements for non-audit mode
https://bugs.eclipse.org/bugs/show_bug.cgi?id=366686

Following a discussion in the newsgroup (news://news.eclipse.org:119/jb2rk6$5ed$1@news.eclipse.org), we have agreed that a suitable solution to performance issues can be the reduction of update statements that are caused by index adjustments after delete/insert/move operations inside a list.

Comment 1 Stefan Winkler

2011-12-21 17:25:21 EST

I have cherry-picked all relevant commits from the master branch into branch bugs/367356

In the final commit, I have done several adjustments to fix the obvious 4.0 compatibility issues:
- eliminated IListMapping2 (and replaced it with a commented cast to BasicAbstractListMapping)
- eliminated the property string constant from CDODBUtil

Also, as discussed via skype, I have changed the option to switch on the performance option. 
To use it, write the following in the cdo-server.xml file:

<mappingStrategy type="horizontalNonAuditing">
        <property name="optimizeIndexManagement" value="true" />
        ....
</mappingStrategy>


Here's the link to the most recent commit. Pushed to git.eclipse.org.

commit d3f8c553e0c29c3ee53f05394ba3e3b5dc067158
Author: Stefan Winkler <stefan@winklerweb.net> 2011-12-21 23:20:07
Committer: Stefan Winkler <stefan@winklerweb.net> 2011-12-21 23:20:07
Parent: 94b56ee41ba3f3d3576125425b768ab96604365e ([367356] [DB] Reduce amount of update statements for non-audit mode https://bugs.eclipse.org/bugs/show_bug.cgi?id=367356)
Branches: bugs/367356

[367356] [DB] Reduce amount of update statements for non-audit mode 
https://bugs.eclipse.org/bugs/show_bug.cgi?id=367356

Adjustments to make the cherry-picked commits conforming to on 4.0

Comment 2 Eike Stepper

2011-12-23 04:13:26 EST

Merged to streams/4.0-maintenance and pushed.

Comment 3 Eike Stepper

2012-09-21 06:51:34 EDT

Closing.