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

Bug 357441

Summary: [DB] Range-based list mappings can be very slow
Product: [Modeling] EMF Reporter: Eike Stepper <stepper>
Component: cdo.dbAssignee: Stefan Winkler <stefan>
Status: NEW --- QA Contact: Eike Stepper <stepper>
Severity: normal    
Priority: P3 CC: saulius.tvarijonas, zstorok
Version: 4.13   
Target Milestone: ---   
Hardware: All   
OS: All   
Whiteboard:
Attachments:
Description Flags
Commit times for 100 products
none
Commit times for 200 products none

Description Eike Stepper CLA 2011-09-13 01:27:07 EDT
I'm about to add a test case to demo this effect...
Comment 1 Eike Stepper CLA 2011-09-13 01:33:14 EDT
Committed revision 9066:
- trunk/plugins/org.eclipse.emf.cdo.tests
Comment 2 Eike Stepper CLA 2011-09-13 01:33:33 EDT
Bugzilla_357441_Test committed
Comment 3 Eike Stepper CLA 2011-09-13 01:34:39 EDT
Created attachment 203206 [details]
Commit times for 100 products
Comment 4 Eike Stepper CLA 2011-09-13 01:35:46 EDT
Created attachment 203207 [details]
Commit times for 200 products

11 minutes total here for 200 commits on 200 products!
Comment 5 Eike Stepper CLA 2011-09-13 01:46:08 EDT
BTW. after committing 200 times on 200 products the Categories_Products_List table contains 37,000 rows.
Comment 6 Eike Stepper CLA 2012-08-14 22:54:15 EDT
Moving all open issues to 4.2. Open bugs can be ported to 4.1 maintenance after they've been fixed in master.
Comment 7 Eike Stepper CLA 2013-06-29 12:19:43 EDT
We'll try to address open problems in 4.3 (master) first and then port fixes back to 4.2.
Comment 8 Eike Stepper CLA 2015-07-14 02:16:31 EDT
Moving all open bugzillas to 4.5.
Comment 9 Eike Stepper CLA 2016-07-31 00:59:29 EDT
Moving all unaddressed bugzillas to 4.6.
Comment 10 Eike Stepper CLA 2017-12-28 01:15:16 EST
Moving all open bugs to 4.7
Comment 11 Eike Stepper CLA 2019-11-08 02:18:09 EST
Moving all unresolved issues to version 4.8-
Comment 12 Eike Stepper CLA 2019-12-13 12:45:12 EST
Moving all unresolved issues to version 4.9
Comment 13 Eike Stepper CLA 2020-12-11 10:36:39 EST
Moving to 4.13.