SEED-platform / seed

Standard Energy Efficiency Data (SEED) Platform™ is a web-based application that helps organizations easily manage data on the energy performance of large groups of buildings.

Other

107 stars 55 forks source link

Sensor reading performance improvement #4464

Closed axelstudios closed 6 months ago

axelstudios commented 6 months ago

What's this PR do?

Removes a long, unnecessary COUNT query, which cuts query time by 40%

How should this be manually tested?

Browse to the sensors page for an org with, ideally, millions of readings

SEED-platform / seed

Sensor reading performance improvement #4464

What's this PR do?

How should this be manually tested?

What are the relevant tickets?

3328