I am proposing to have the ability to configure the worker threads in a way that allows two pools:
- Reserve the Number of workers for only where known query duration is <= x seconds.
- Allow any query on the rest of the workers.
EXAMPLE: Set 2 of the worker threads to only operate on Known queries that take less than 2 seconds to complete.
This may help when long running queries completely block all other queries. This tactic ensures small effecient queries (which should be 99% of all queries) always have a chance of getting run quickly.