View Issue Details

IDProjectCategoryView StatusLast Update
0000524Adam4EVEBugpublic2018-02-09 15:06
ReporterSuccessor Assigned ToSuccessor  
PrioritynormalSeverityminorReproducibilityhave not tried
Status resolvedResolutionfixed 
Target Version0.0.14Fixed in Version0.0.14 
Summary0000524: Querytime of station price history vs. region price history
DescriptionThere is a huge difference in the query time between station and region price history tables even though both tables are roughtly the same size and number of rows. Station is finished within a few millisecs. Region in 2 secs.
TagsNo tags attached.
Attach Tags



2018-02-09 15:06

administrator   ~0000374

Wow, solution was the order of the columns in the primary key. Didn't know that this order is relevant.

But once the order of the columns in region was the same as in the station table, the queries are very fast as well.

Issue History

Date Modified Username Field Change
2018-02-09 15:05 Successor New Issue
2018-02-09 15:05 Successor Status new => assigned
2018-02-09 15:05 Successor Assigned To => Successor
2018-02-09 15:06 Successor Note Added: 0000374
2018-02-09 15:06 Successor Status assigned => resolved
2018-02-09 15:06 Successor Fixed in Version => 0.0.14
2018-02-09 15:06 Successor Resolution open => fixed