Bug 456785 - Improve revisions prefetch
Summary: Improve revisions prefetch
Status: NEW
Alias: None
Product: EMF
Classification: Modeling
Component: cdo.net4j.db (show other bugs)
Version: 4.13   Edit
Hardware: PC Linux
: P3 enhancement (vote)
Target Milestone: ---   Edit
Assignee: Project Inbox CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-01-06 07:02 EST by Esteban DUGUEPEROUX CLA
Modified: 2020-12-11 10:45 EST (History)
0 users

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Esteban DUGUEPEROUX CLA 2015-01-06 07:02:40 EST 
This bugzilla is raised to study means to improve revisions prefetch and have performance tests to see improvements.
Comment 1 Esteban DUGUEPEROUX CLA 2015-01-06 07:59:55 EST 
I have added a JUnit class RevisionsPrefetchPerformanceTests : https://git.eclipse.org/r/#/c/39035/
Comment 2 Eike Stepper CLA 2015-07-14 02:13:18 EDT 
Moving all open bugzillas to 4.5.
Comment 3 Eclipse Genie CLA 2016-03-23 10:21:59 EDT 
New Gerrit change created: https://git.eclipse.org/r/69149
Comment 4 Esteban DUGUEPEROUX CLA 2016-03-23 10:33:05 EDT 
I have pushed https://git.eclipse.org/r/69149 on gerrit as draft to not lose it.
This draft consists to do a readRevisions on ClassMapping in batch to decrease the number of SQL requests. The initial idea was to use a "SELECT IN [...]" request [1] but this is prevented by JDBC API to avoid potential SQL injection attack [2]. The next step was to test the different strategies explained in [2].
I have briefly studied the use of recursive SQL request (CTE) but this seems to complex and not supported by all majors RDBMS.

[1] http://sql.sh/cours/where/in
[2] http://www.javaranch.com/journal/200510/Journal200510.jsp#a2
[3] https://msdn.microsoft.com/fr-fr/library/ms175972(v=sql.120).aspx

This task is in work interrupted.

Eike has done some commits to improve drastically revisions loading, see Bug 486458, but with some contraints like object move forbidden.
Comment 5 Eike Stepper CLA 2016-07-31 00:55:58 EDT 
Moving all unaddressed bugzillas to 4.6.
Comment 6 Eike Stepper CLA 2017-12-28 01:20:21 EST 
Moving all open bugs to 4.7
Comment 7 Eike Stepper CLA 2019-11-08 02:06:33 EST 
Moving all unresolved issues to version 4.8-
Comment 8 Eike Stepper CLA 2019-12-13 12:48:58 EST 
Moving all unresolved issues to version 4.9
Comment 9 Eike Stepper CLA 2020-12-11 10:45:30 EST 
Moving to 4.13.