NTIA / scos-sensor

NTIA/ITS Spectrum Monitoring SCOS sensor reference implementation
Other
20 stars 15 forks source link

SQL query on /tasks/completed endpoint can be very slow #149

Open djanderson opened 5 years ago

djanderson commented 5 years ago

Django ORM queries were written naively for speed of development. At this point, it's probably worth spending the time to determine hot queries and tweaking them.

One of the worst offenders is /tasks/completed/{schedule_entry_name} when the entry holds a lot of acquisitions, for example a stepped_freq_tdomain_iq.

To test,

djanderson commented 5 years ago

Screenshot from 2019-06-06 13-33-49

Screenshot from 2019-06-06 13-34-24