• Julien Muchembled's avatar
    CMFActivity: try to reserve older messages first (ORDER BY priority, date) · 275799fe
    Julien Muchembled authored
    This reverts commit 2a84df59 partially.
    With a good index, requests should be fast enough to avoid locks.
    
    Use following requests to update activity tables:
    
    ALTER TABLE message DROP KEY processing_node_date, ADD KEY processing_node_priority_date (processing_node, priority, date);
    ALTER TABLE message_queue DROP KEY processing_node_date, ADD KEY processing_node_priority_date (processing_node, priority, date);
    275799fe
SQLQueue_createMessageTable.zsql 1.08 KB