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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0032643
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Retail Modules] Web POSmajoralways2016-04-05 10:552016-04-20 16:29
ReportermalsasuaView Statuspublic 
Assigned Tomigueldejuana 
PriorityhighResolutionfixedFixed in VersionRR16Q2
StatusclosedFix in branchFixed in SCM revisionb1b9eed762c6
ProjectionnoneETAnoneTarget VersionRR16Q2
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionRR16Q1SCM revision 
Review Assigned Tomarvintm
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0032643: product characteristics filters is not working with a big data

Descriptionin a environment with a big volume data:
>6.000 products
>67.000 product characteristic values

when you try to filter the sencond time, the "loading window" is displayed and never is hidden
Steps To Reproducein environment with
>6.000 products
>67.000 product characteristic values
. go to search tab
. click in one product characteristict (for example, color)
. select one color (for example, blue)
. click in done
. click in color again
. unselect the color blue
. click in done

loading window is displayed and never is hidden
(see video)
Proposed Solutionverify the remote data code to see if there are improvements that could be applied to the standard flow. e.g:
in the queries:
- change 'in's by 'exists'
- add indexes where missing
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0032592 closedmigueldejuana product characteristics filters is not working with a big data 

-  Notes
(0085708)
hgbot (developer)
2016-04-18 13:40

 Repository: retail/backports/3.0RR16Q2/org.openbravo.mobile.core
Changeset: b1b9eed762c6500e16442acbbd59a5e2fa961351
Author: Miguel de Juana <miguel.dejuana <at> openbravo.com>
Date: Mon Apr 18 13:40:18 2016 +0200
URL: http://code.openbravo.com/retail/backports/3.0RR16Q2/org.openbravo.mobile.core/rev/b1b9eed762c6500e16442acbbd59a5e2fa961351 [^]

Fixed issue 0032643: product characteristics filters is not working with a big data

- Show loading... also in characteristics table in Search tab

---
M web/org.openbravo.mobile.core/source/retail/component/ob-retail-searchproductcharacteristic.js
---
(0085709)
migueldejuana (developer)
2016-04-18 13:43

 author Miguel de Juana <miguel.dejuana@openbravo.com>
Mon Apr 18 13:41:08 2016 +0200 (69 seconds ago)
changeset 6243 943696586270
parent 6242 202b0d7e2a03
Fixed issue 00325643: product characteristics filters is not working with a big data

-Add an index to product characteristic table to improve search perfomance

https://code.openbravo.com/retail/backports/3.0RR16Q2/org.openbravo.retail.posterminal/rev/943696586270 [^]

- Issue History
Date Modified Username Field Change
2016-04-11 12:14 migueldejuana Type defect => backport
2016-04-11 12:14 migueldejuana Target Version => RR16Q2
2016-04-18 13:40 hgbot Checkin
2016-04-18 13:40 hgbot Note Added: 0085708
2016-04-18 13:40 hgbot Status scheduled => resolved
2016-04-18 13:40 hgbot Resolution open => fixed
2016-04-18 13:40 hgbot Fixed in SCM revision => http://code.openbravo.com/retail/backports/3.0RR16Q2/org.openbravo.mobile.core/rev/b1b9eed762c6500e16442acbbd59a5e2fa961351 [^]
2016-04-18 13:43 migueldejuana Note Added: 0085709
2016-04-20 16:29 marvintm Review Assigned To => marvintm
2016-04-20 16:29 marvintm Status resolved => closed
2016-04-20 16:29 marvintm Fixed in Version => RR16Q2

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker