i'm getting `Error: D1_ERROR: D1 is
i'm getting
Error: D1_ERROR: D1 is overloaded. Too many requests queued. for the last while. its a tiny little d1 database with no traffic3 Replies
database id
aa76b36d-692e-423b-9718-aabfafb4588acan see it erroring quite a bit - what kind of query is it running?
It was running just a basic select across a few columns. Nothing had changed when it started happening. It’s an app for myself basically.
SELECT DISTINCT releases.name, releases.group, releases.category, releases.size, releases.files,
releases.resolution, releases.source, releases.updatedAt, releases.imdb_id
FROM releases
LEFT JOIN movies ON movies.imdb_id = releases.imdb_id
WHERE (
movies.imdb_rating_votes > ? AND releases.resolution = ? AND releases.name not like ?
)
ORDER BY releases.updated_at DESC
LIMIT ?
i think i found a place i was missing an index