Bug 357441 - [DB] Range-based list mappings can be very slow
Summary: [DB] Range-based list mappings can be very slow
Status: NEW
Alias: None
Product: EMF
Classification: Modeling
Component: cdo.db (show other bugs)
Version: 4.13   Edit
Hardware: All All
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Stefan Winkler CLA
QA Contact: Eike Stepper CLA
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-09-13 01:27 EDT by Eike Stepper CLA
Modified: 2020-12-11 10:36 EST (History)
2 users (show)

See Also:

Attachments
Commit times for 100 products (23.77 KB, image/png)
2011-09-13 01:34 EDT, Eike Stepper CLA 		no flags Details
Commit times for 200 products (27.15 KB, image/png)
2011-09-13 01:35 EDT, Eike Stepper CLA 		no flags Details
View All 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 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.