Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0031393
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2015-11-06 13:262015-11-19 10:14
ReporterdaniOpenbravoView Statuspublic 
Assigned ToSandrahuguet 
PriorityhighResolutionfixedFixed in VersionRR16Q1
StatusclosedFix in branchFixed in SCM revision23bc14aa8b01
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabaseOracleJava version1.7
OS Version14.04Database version12cAnt version
Product VersionSCM revision 
Review Assigned Tomtaal
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0031393: [HGVOL] Price List Model loading

DescriptionBad performance when loading Price List model in Web POS if we have a high amount of customers in the database (In this case 2.500.000).
Steps To Reproduce- Log in Web POS.
- Loading "Price List" model takes a long period of time as the quantity of customers is too high.
Proposed SolutionCreating the following index (oracle version) gets much better performance:

CREATE INDEX c_bpartner_pricelist ON c_bpartner(m_pricelist_id) TABLESPACE users;
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0081917)
hgbot (developer)
2015-11-17 11:03

Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 23bc14aa8b01d493a52369b68aad935fcc5c68d7
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Mon Nov 16 16:41:16 2015 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/23bc14aa8b01d493a52369b68aad935fcc5c68d7 [^]

Fixed bug 31393: [HGVOL] Price List Model loading

---
A src-db/database/model/modifiedTables/C_BPARTNER.xml
---
(0081969)
mtaal (manager)
2015-11-19 10:14

Tested in BUT environment, solves it there, change looks fine, closing

- Issue History
Date Modified Username Field Change
2015-11-06 13:26 daniOpenbravo New Issue
2015-11-06 13:26 daniOpenbravo Assigned To => Sandrahuguet
2015-11-06 13:26 daniOpenbravo Triggers an Emergency Pack => No
2015-11-06 14:24 daniOpenbravo Issue Monitored: daniOpenbravo
2015-11-09 09:55 Sandrahuguet Status new => scheduled
2015-11-16 11:21 Orekaria Resolution time => 1447974000
2015-11-17 11:03 hgbot Checkin
2015-11-17 11:03 hgbot Note Added: 0081917
2015-11-17 11:03 hgbot Status scheduled => resolved
2015-11-17 11:03 hgbot Resolution open => fixed
2015-11-17 11:03 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/23bc14aa8b01d493a52369b68aad935fcc5c68d7 [^]
2015-11-17 11:04 Sandrahuguet Review Assigned To => mtaal
2015-11-19 10:14 mtaal Note Added: 0081969
2015-11-19 10:14 mtaal Status resolved => closed
2015-11-19 10:14 mtaal Fixed in Version => RR16Q1


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker