Bug 780101

Summary: Potential perfromance issues with ModeShape
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Jiri Pechanec <jpechane>
Component: ToolingAssignee: Van Halbert <vhalbert>
Status: CLOSED DUPLICATE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 6.0.0CC: atangrin, no-reply, pmacik, soa-p-jira, vhalbert
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-2470
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: 780100 Environment:
Last Closed: 2012-07-13 15:56:08 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Attachments:
Description Flags
source.zip
none
perfresult.ods
none
perfresult_modeshape_from_SOAER6.ods
none
perfresult_5.2_ER5.ods none

Description Jiri Pechanec 2010-10-25 07:23:19 UTC 
++ This bug is a clone of bug 780100 ++

project_key: SOA

Attached test report contains 4 scenarios tested against default EDS repository. I tried to run tests against PostgreSQL and they exhibits the same behaviour

1) DepthOnlyPerformanceTest - new nodes are added to increase the depth of tree. The nodes are added in batches of ten nodes. Both write and read operations shows exponential increase of operation time with enlarging tree depth.
2) BreadthOnlyPerformanceTest - new nodes are added to simulate enlarging number of data stored in repository. The read operation time is constant, write operation time is linearly increasing with the number of records in repository.
3) PropertiesOnlyPerformanceTest - new properties are added to a single node. No issue - constant read and write time with increased number of properties.
4) ComplexPerfromaceTest - new nodes are added with depth 5, the leaf node always contains  five properties, one of which is bigger. The scenario shows the same behaviour as BreadthOnlyPerformanceTest.

I am attaching also test report charts and source code.
Comment 1 Jiri Pechanec 2010-10-25 07:24:16 UTC 
Attachment: Added: source.zip
Attachment: Added: perfresult.ods
Comment 2 Anne-Louise Tangring 2010-10-28 16:08:27 UTC 
Candidate for SOA 5.1.0. Van will see if Brian can take a look.
Comment 3 Van Halbert 2010-11-10 14:50:03 UTC 
Link: Added: This issue depends MODE-923
Comment 4 Van Halbert 2010-12-01 18:31:49 UTC 
Changes have been committed to fix a performance issue.   Can the tests be rerun to verify improvement?
Comment 5 Pavel Macik 2010-12-03 10:36:17 UTC 
Link: Added: This issue related JBQA-4030
Comment 6 Petr Široký 2010-12-07 14:32:55 UTC 
Link: Added: This issue related BRMS-502
Comment 7 Petr Široký 2011-01-05 15:38:36 UTC 
I reran the the tests and the results are almost same as before. (graphs are in attached ods file). There are some small changes, but the tests was ran on the diffenrent databases, so this could be the reason.

Note: Original tests were run with local PostgreSQL DB. I ran them with remote Oracle 10g DB.
Comment 8 Petr Široký 2011-01-05 15:38:36 UTC 
Attachment: Added: perfresult_modeshape_from_SOAER6.ods
Comment 9 Van Halbert 2011-01-12 15:33:35 UTC 
Security: Removed: Public Added: JBoss Internal
Comment 10 Jiri Locker 2011-03-01 12:05:32 UTC 
Link: Added: This issue is related to BRMS-502
Comment 11 Van Halbert 2011-06-01 19:11:43 UTC 
There is retesting targeted for 5.2 based on the BRMS-502
Comment 12 Van Halbert 2011-06-02 19:24:36 UTC 
Retesting required
Comment 13 RH Bugzilla Integration 2011-08-16 15:21:10 UTC 
Randall Hauch <rhauch> made a comment on [bug 724554|https://bugzilla.redhat.com/show_bug.cgi?id=724554]

I would agree that "createSnapshot" does perform significantly slower than JR, but the other performance numbers are not significantly higher than with JR. Obviously we're still trying to improve performance, though it's not likely we can get much improvement by the release.
Comment 14 David Le Sage 2011-09-01 05:52:32 UTC 
Release Notes Docs Status: Added: Not Required
Writer: Added: dlesage
Comment 15 RH Bugzilla Integration 2011-09-01 23:52:57 UTC 
Bugzilla References: Added: https://bugzilla.redhat.com/show_bug.cgi?id=724554
Comment 16 Van Halbert 2011-10-11 15:47:44 UTC 
Bugzilla References: Removed: https://bugzilla.redhat.com/show_bug.cgi?id=724554 Added: https://bugzilla.redhat.com/show_bug.cgi?id=724554
Comment 17 Jiri Pechanec 2011-10-21 10:15:03 UTC 
Tried in 5.2 ER5, behaviour is almost the same, see attached results. Tests were done with PostgreSQL.Did you try to analyze SQL commands to verify that all is optimal and properly indexed?
Comment 18 Jiri Pechanec 2011-10-21 10:15:23 UTC 
Attachment: Added: perfresult_5.2_ER5.ods
Comment 19 Pavel Macik 2011-10-24 11:45:24 UTC 
I run the tests against 510GA and 520ER5 with Oracle10g and the results are almost the same too.
Comment 20 Pavel Macik 2011-10-25 08:37:48 UTC 
Actually there is a performance regression in case of "Depth only" scenario. See the "ModeShape Charts" sheet of the results document (https://docspace.corp.redhat.com/docs/DOC-24649).
Comment 21 Anne-Louise Tangring 2011-11-03 17:24:52 UTC 
Bugzilla References: Removed: https://bugzilla.redhat.com/show_bug.cgi?id=724554 Added: https://bugzilla.redhat.com/show_bug.cgi?id=724554
Comment 22 Anne-Louise Tangring 2011-11-03 17:52:09 UTC 
The next major version of ModeShape will target this area.
Comment 23 Anne-Louise Tangring 2011-11-03 17:52:09 UTC 
Bugzilla References: Removed: https://bugzilla.redhat.com/show_bug.cgi?id=724554 Added: https://bugzilla.redhat.com/show_bug.cgi?id=724554
Comment 25 Van Halbert 2011-11-22 13:27:14 UTC 
Bugzilla References: Removed: https://bugzilla.redhat.com/show_bug.cgi?id=724554 Added: https://bugzilla.redhat.com/show_bug.cgi?id=724554
Comment 26 Van Halbert 2012-07-13 15:56:08 UTC 

*** This bug has been marked as a duplicate of bug 780100 ***