@tsteur opened this Pull Request on September 2nd 2019 Member

Not expecting a big change in performance here. But generally it's better to have two simple queries that can be fully read from index instead of joining the tables etc. The join should be straight forward though as well because it should be also created based on the index, however the two individual queries should be still faster.

Also another tweak is that for deleted sites we don't need to look at ts_archived. This actually does make things quite a bit faster.

This Pull Request was closed on September 3rd 2019
Powered by GitHub Issue Mirror