Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 367356 - [DB] Reduce amount of update statements for non-audit mode
Summary: [DB] Reduce amount of update statements for non-audit mode
Status: CLOSED FIXED
Alias: None
Product: EMF
Classification: Modeling
Component: cdo.db (show other bugs)
Version: 4.0   Edit
Hardware: All All
: P3 enhancement (vote)
Target Milestone: ---   Edit
Assignee: Stefan Winkler CLA
QA Contact: Eike Stepper CLA
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: 272475
  Show dependency tree
 
Reported: 2011-12-21 12:18 EST by Eike Stepper CLA
Modified: 2012-09-21 06:51 EDT (History)
0 users

See Also:
stepper: review+


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Eike Stepper CLA 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 CLA 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 CLA 2011-12-23 04:13:26 EST
Merged to streams/4.0-maintenance and pushed.
Comment 3 Eike Stepper CLA 2012-09-21 06:51:34 EDT
Closing.