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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0040615
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Advance Warehouse Operationsmajoralways2019-04-15 12:292019-05-08 13:28
Reporterjoniturralde93View Statuspublic 
Assigned Toguilleaer 
PriorityurgentResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0040615: Task loading can be very slow [Frontend]

DescriptionPerformance problem when loading tasks.
- 1100 products (160 of them with assigned attribute sets (a lot of possible values))
- 163 attributes

In local machine, the requests lasts for around 30 seconds.
Attached both executed queries in backend and explain analyze for each one.
Steps To Reproduce- Login/refresh awo frontend, or click menu option "Refresh"
TagsNo tags attached.
Attached Files file icon Query1 [^] (10,406 bytes) 2019-04-15 12:29 [Show Content]
 file icon Query2 [^] (10,810 bytes) 2019-04-15 12:31 [Show Content]
 file icon explain1 [^] (30,543 bytes) 2019-04-15 12:31 [Show Content]
 file icon explain2 [^] (30,765 bytes) 2019-04-15 12:31 [Show Content]
png file icon explain1.png [^] (332,635 bytes) 2019-04-15 12:31
png file icon explain2.png [^] (312,940 bytes) 2019-04-15 12:31

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2019-04-15 12:29 joniturralde93 New Issue
2019-04-15 12:29 joniturralde93 Assigned To => Triage Finance
2019-04-15 12:29 joniturralde93 File Added: Query1
2019-04-15 12:31 joniturralde93 File Added: Query2
2019-04-15 12:31 joniturralde93 File Added: explain1
2019-04-15 12:31 joniturralde93 File Added: explain2
2019-04-15 12:31 joniturralde93 File Added: explain1.png
2019-04-15 12:31 joniturralde93 File Added: explain2.png
2019-04-15 12:31 joniturralde93 Description Updated View Revisions
2019-04-15 12:42 Sandrahuguet Assigned To Triage Finance => guilleaer


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker