Increase trade query performance by indexing database columns

ed-pilots-network / backend

Project to consume the Kafka, process the messages and provide an API to access the data

Apache License 2.0

12 stars 5 forks source link

Increase trade query performance by indexing database columns #151

Closed Daniel-J-Mason closed 3 months ago

Daniel-J-Mason commented 4 months ago

Current trade database is quite bare-bones. It is worth starting to index the frequently searched fields so we can improve these query response times.

Proposed indexes are: station: arrival distance latest_market_data: supply, demand, price

Daniel-J-Mason commented 4 months ago

Current trade database is quite bare-bones. It is worth starting to index the frequently searched fields so we can improve these query response times.

Proposed indexes are: station: arrival distance latest_market_data: supply, demand, price

removing max_landing_pad_size from station indexes, cardinality is too low to be useful