Add index to the "processed" column

Created on 24 November 2022, over 1 year ago
Updated 25 January 2023, over 1 year ago

Problem/Motivation

Now that ✨ Allow deleting completed jobs after a certain number Fixed is in, we're doing a query based on the processed time.

Since we don't have an index on this column, the performance of that query can be very problematic for sites with a large number of queue jobs since the query will have to scan all rows.

📌 Task
Status

Fixed

Version

1.0

Component

Code

Created by

🇮🇱Israel jsacksick

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Production build 0.69.0 2024