Add indices to frequently queried columns in the scheduler.

ababaian / serratus

Ultra-deep search for novel viruses

http://serratus.io

GNU General Public License v3.0

253 stars 33 forks source link

Add indices to frequently queried columns in the scheduler. #82

Closed brietaylor closed 4 years ago

brietaylor commented 4 years ago

Add indices to the "state" columns. This is a quick performance update. Not sure if this is actually a hotspot in the scheduler, but it improves performance quite a lot on the database queries, so it should have a positive effect on performance.