Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037641Openbravo ERPA. Platformpublic2018-01-15 17:352018-02-22 18:18
ReporterAugustoMauch 
Assigned ToAugustoMauch 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR18Q2 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0037641: Make the max size of Hibernate's HqlQueryPlan cache configurable
DescriptionThe QueryPlanCache Hibernate class acts as a cache for compiled query plans. Having this cache properly dimentioned helps to optimize Hibernate's performace.

There are two parameters that can be configured: one for the maximum number of strong references (128 by default) and one for soft references (2048 by default). But these parameters are currently not configurable in Openbravo.


It would be useful if the dimension of this cache were configurable in Openbravo.properties.
Steps To Reproduce-
Proposed SolutionAllow to configure Hibernate's query plan cache size in Openbravo properties with the parameters hibernate.query.plan_cache_max_strong_references and hibernate.query.plan_cache_max_soft_references
Additional Information
TagsPerformance
Relationships
related to design defect 0038136 acknowledged Triage Platform Base Tracking issue: Find & Fix queries not using bind-params but embedding values into query string 
related to feature request 0037064 closed caristu upgrade hibernate to 5.3.2 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-01-15 17:35AugustoMauchNew Issue
2018-01-15 17:35AugustoMauchAssigned To => AugustoMauch
2018-01-15 17:35AugustoMauchModules => Core
2018-01-15 17:35AugustoMauchTriggers an Emergency Pack => No
2018-01-15 17:38AugustoMauchReview Assigned To => caristu
2018-01-15 17:41hgbotCheckin
2018-01-15 17:41hgbotNote Added: 0101709
2018-01-15 17:41hgbotStatusnew => resolved
2018-01-15 17:41hgbotResolutionopen => fixed
2018-01-15 17:41hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/de556f74afd615d9666c059d1869fdb6057e7319 [^]
2018-01-19 07:58alostaleTag Attached: Performance
2018-01-22 11:32caristuNote Added: 0101828
2018-01-22 11:32caristuStatusresolved => closed
2018-01-22 11:32caristuFixed in Version => 3.0PR18Q2
2018-02-22 18:18hudsonbotCheckin
2018-02-22 18:18hudsonbotNote Added: 0102657
2018-03-16 10:01alostaleRelationship addedrelated to 0038136
2018-05-03 10:38caristuRelationship addedrelated to 0037064

Notes
(0101709)
hgbot   
2018-01-15 17:41   
Repository: erp/devel/pi
Changeset: de556f74afd615d9666c059d1869fdb6057e7319
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Mon Jan 15 17:40:00 2018 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/de556f74afd615d9666c059d1869fdb6057e7319 [^]

Fixes issue 37641: Allows to configure Hibernate's hql query plan cache size

Now the max size of Hibernate's HQL query plan cache can be configured in Openbravo.properties by defining the
hibernate.query.plan_cache_max_strong_references and hibernate.query.plan_cache_max_soft_references properties.

---
M src/org/openbravo/base/session/SessionFactoryController.java
---
(0101828)
caristu   
2018-01-22 11:32   
Code reviewed + tested OK.
(0102657)
hudsonbot   
2018-02-22 18:18   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/980a6ad5bbf5 [^]
Maturity status: Test