juriansluiman/SlmQueueDoctrine — pull request #47 by basz (2014-01-02 20:36:56+00:00)
Title: adds index on status

by adding an index on the 'status' field 'long' running queries are prevented... according from the long query log

not sure why that would happen only with an tinyint field and not with the other fields that the queue uses to pull jobs...

```
SELECT * FROM queue_default WHERE status = 1 AND queue = 'main' AND scheduled <= '2014-01-02 21:14:09' ORDER BY scheduled ASC LIMIT 1 FOR UPDATE;
```