View Issue Details

IDProjectCategoryView StatusLast Update
0000301Adam4EVEFeature Requestpublic2017-03-24 09:00
ReporterSuccessor Assigned ToSuccessor  
PrioritynormalSeverityminorReproducibilityhave not tried
Status resolvedResolutionfixed 
Product Version0.0.9 
Target Version0.0.10Fixed in Version0.0.10 
Summary0000301: Price history - Change database schema
DescriptionThe average calculation on each price history request is taking a lot of time and CPU. And it is not relevant anymore for historic prices.

Thus change the schema to have the history tables with calculated values and introduce a cache table that stores the values of today to calculate the average.
TagsNo tags attached.

Activities

Successor

2017-03-24 09:00

administrator   ~0000207

Schema created and permissions set

Issue History

Date Modified Username Field Change
2017-03-24 08:59 Successor New Issue
2017-03-24 08:59 Successor Status new => assigned
2017-03-24 08:59 Successor Assigned To => Successor
2017-03-24 09:00 Successor Note Added: 0000207
2017-03-24 09:00 Successor Status assigned => resolved
2017-03-24 09:00 Successor Fixed in Version => 0.0.10
2017-03-24 09:00 Successor Resolution open => fixed