Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0043274 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] I. Performance | minor | have not tried | 2020-02-19 18:06 | 2020-04-08 09:35 | |||
| Reporter | ALopetegui | View Status | public | |||||
| Assigned To | AtulOpenbravo | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 3.0PR20Q2 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | e7a36bdb9a09 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | dmiguelez | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0043274: Payment In/Out Window bad performance because documentno index is missing | |||||||
| Description | The windows Payment in/Out have an Order by clause with documentno in the definition, for this reason all default searches will order by (documentno, fin_payment_id) . However, there is not index by those values. For that reason the window is very slow, specially with high volumes. | |||||||
| Steps To Reproduce | In a high volume environment, open payment in or out window and search without ordering by anything, the default search will order by (documentno, fin_payment_id) and it is slow. | |||||||
| Proposed Solution | Create an index in fin_payment by (documentno, fin_payment_id) Attached diff file. | |||||||
| Tags | Performance | |||||||
| Attached Files |  newIndex.diff [^] (718 bytes) 2020-02-19 18:06 [Show Content]
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0118110) hgbot (developer) 2020-02-26 10:45 |
Repository: erp/devel/pi Changeset: e7a36bdb9a0924117cc6cc2871487b30012a00ca Author: Atul Gaware <atul.gaware <at> openbravo.com> Date: Thu Feb 20 23:32:45 2020 +0530 URL: http://code.openbravo.com/erp/devel/pi/rev/e7a36bdb9a0924117cc6cc2871487b30012a00ca [^] Fixes BUG-0043274: Payment In/Out Window bad performance because documentno index is missing **Add index in FIN_Payment for column documentno and fin_payment_id --- M src-db/database/model/tables/FIN_PAYMENT.xml --- |
|
(0118112) dmiguelez (developer) 2020-02-26 10:47 |
Tested in client |
|
(0118113) dmiguelez (developer) 2020-02-26 10:49 |
Code Review + Testing Ok |
|
(0119087) hgbot (developer) 2020-04-08 09:35 |
Repository: erp/pmods/org.openbravo.retail.highvolumesconfig Changeset: 47e71ebedd53923ed71451004ef2f4abfeb1c9f2 Author: Gorka Gil <gorka.gil <at> openbravo.com> Date: Wed Apr 08 09:35:14 2020 +0200 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.highvolumesconfig/rev/47e71ebedd53923ed71451004ef2f4abfeb1c9f2 [^] Delete index, since was already added to pi in ISSUE-43274 --- M src-db/database/model/modifiedTables/FIN_PAYMENT.xml --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2020-02-19 18:06 | ALopetegui | New Issue | |
| 2020-02-19 18:06 | ALopetegui | Assigned To | => platform |
| 2020-02-19 18:06 | ALopetegui | File Added: newIndex.diff | |
| 2020-02-19 18:06 | ALopetegui | Modules | => Core |
| 2020-02-19 18:06 | ALopetegui | Triggers an Emergency Pack | => No |
| 2020-02-19 18:06 | ALopetegui | Relationship added | related to 0030836 |
| 2020-02-19 18:06 | ALopetegui | Tag Attached: Performance | |
| 2020-02-20 14:23 | AtulOpenbravo | Assigned To | platform => AtulOpenbravo |
| 2020-02-20 14:23 | AtulOpenbravo | Status | new => acknowledged |
| 2020-02-20 14:23 | AtulOpenbravo | Status | acknowledged => scheduled |
| 2020-02-26 10:45 | hgbot | Checkin | |
| 2020-02-26 10:45 | hgbot | Note Added: 0118110 | |
| 2020-02-26 10:45 | hgbot | Status | scheduled => resolved |
| 2020-02-26 10:45 | hgbot | Resolution | open => fixed |
| 2020-02-26 10:45 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/e7a36bdb9a0924117cc6cc2871487b30012a00ca [^] |
| 2020-02-26 10:47 | dmiguelez | Note Added: 0118112 | |
| 2020-02-26 10:49 | dmiguelez | Review Assigned To | => dmiguelez |
| 2020-02-26 10:49 | dmiguelez | Note Added: 0118113 | |
| 2020-02-26 10:49 | dmiguelez | Status | resolved => closed |
| 2020-02-26 10:49 | dmiguelez | Fixed in Version | => 3.0PR20Q2 |
| 2020-04-08 09:35 | hgbot | Checkin | |
| 2020-04-08 09:35 | hgbot | Note Added: 0119087 | |
| 2020-06-10 09:23 | ALopetegui | Relationship added | causes 0044324 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |