Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0046176

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

defect

[Openbravo ERP] I. Performance

major

always

2021-03-30 07:25

2021-04-07 12:22

Reporter

jetxarri

View Status

public

Assigned To

jetxarri

Priority

high

Resolution

open

Fixed in Version

Status

feedback

Fix in branch

Fixed in SCM revision

Projection

none

ETA

none

Target Version

OS

Any

Database

Any

Java version

OS Version

Database version

Ant version

Product Version

PR20Q3.4

SCM revision

Review Assigned To

Web browser

Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox

Modules

Core

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0046176: Create an index in ad_preference table to execute read statements faster

Description

Currently there are 2 types of preferences, using the property list or not, so it is interesting to create an index in that column

Steps To Reproduce

-

Proposed Solution

Attached file

Tags

patch.diff [^] (1,052 bytes) 2021-03-30 07:25 [Show Content] [Hide Content]

From 8af4a5b81bdbd3d4c7dc3b4b7abe8948b23a2fbc Mon Sep 17 00:00:00 2001
From: Javier Etxarri <javier.echarri@openbravo.com>
Date: Wed, 17 Mar 2021 09:02:02 +0100
Subject: [PATCH] Related to issue NOE_3074: When getting properties, the query
 is improved adding and index in ispropertylist, it is 6-7 times faster

---
 src-db/database/model/tables/AD_PREFERENCE.xml | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/src-db/database/model/tables/AD_PREFERENCE.xml b/src-db/database/model/tables/AD_PREFERENCE.xml
index bd7100eee1..9143ad7dd6 100644
--- a/src-db/database/model/tables/AD_PREFERENCE.xml
+++ b/src-db/database/model/tables/AD_PREFERENCE.xml
@@ -111,6 +111,9 @@
       <index name="AD_PREFERENCE_ATTR_IDX" unique="false">
         <index-column name="ATTRIBUTE"/>
       </index>
+      <index name="AD_PREFERENCE_ISPRLIST_IDX" unique="false">
+        <index-column name="ISPROPERTYLIST"/>
+      </index>
       <index name="AD_PREFERENCE_LIST_IDX" unique="false">
         <index-column name="PROPERTY"/>
       </index>
-- 
2.27.0

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	defect	0046177		feedback	jetxarri	Avoid ordering preferences by id because it only adds time to the statement execution
depends on	defect	0046178		closed	markmm82	Avoid trying to find the general ledger configuration if it is not configured in any organization

Notes
(0127130) alostale (manager) 2021-04-07 12:21	Could you please detail in which cases (queries and data distribution) this index helps?

Issue History
Date Modified	Username	Field	Change
2021-03-30 07:25	jetxarri	New Issue
2021-03-30 07:25	jetxarri	Assigned To	=> platform
2021-03-30 07:25	jetxarri	File Added: patch.diff
2021-03-30 07:25	jetxarri	Web browser	=> Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox
2021-03-30 07:25	jetxarri	Modules	=> Core
2021-03-30 07:25	jetxarri	Triggers an Emergency Pack	=> No
2021-03-30 17:33	rafaroda	Web browser	Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox => Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox
2021-03-30 17:33	rafaroda	Resolution time	=> 1618264800
2021-03-30 17:33	rafaroda	Tag Attached: NOR
2021-03-30 17:33	rafaroda	Relationship added	related to 0046177
2021-03-30 17:33	rafaroda	Relationship added	depends on 0046178
2021-03-31 12:38	rafaroda	Web browser	Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox => Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox
2021-03-31 12:38	rafaroda	Severity	minor => major
2021-04-07 12:21	alostale	Note Added: 0127130
2021-04-07 12:21	alostale	Status	new => feedback
2021-04-07 12:22	alostale	Assigned To	platform => jetxarri

Copyright © 2000 - 2009 MantisBT Group