[yii\queue\db\Queue::reserve()] is extremely slow if there are many delayed jobs #280
Description
What steps will reproduce the problem?
Make DB queue with 200k+ jobs on delayed list
What's expected?
fetching jobs from queue should be fast
What do you get instead?
since fetching jobs from queue takes 3+ seconds, additional workers get mutex timeout
Additional info
| Q | A |
|---|---|
| Yii version | 2.0.15.1 |
| PHP version | 7.2.9 |
| Operating system | Debian 9 |