Comment - FBXL Lotide

Comment on @Hubzilla Support Forum If you are under reliatively fresh MySQL 8 then try

kostikov@zotum.net@zotum.net ⁨1⁩ ⁨day⁩ ago

@Mario Vavti
Without `worker_id`, since omitting `worker_reservationid` did not have a positive effect.
ALTER TABLE workerq ADD INDEX idx_claim (workerq_reservationid, workerq_priority DESC);

original

Sort:hotnew top

mario@hub.somaton.com@hub.somaton.com ⁨1⁩ ⁨day⁩ ago

@Max Kostikov ah... that is somehow suprising...

Anyway, i think i will go with

ALTER TABLE workerq
    ADD INDEX idx_claim (
        workerq_reservationid,
        workerq_priority DESC,
        workerq_id ASC
    );

as you suggested first.

original