| Commit message (Collapse) | Author | Lines |
|---|
|
|
|
This means the other, larger, columns do not need to be deserialised, bringing the query time down from 7.4s down to 3.5s.
I couldn't simply do select(models.User.id) here, as we need the full User object in order to mutate and update it later inthe process.
|
|
Previously we set all users in_guild to False, and relied on users being set back to in_guild when iterating through guild.members
However, this caused two problems
1. For a short window a users in_guild status was incorrect
2. It required an update for all users in_guild to be sent to postgres to update in_guild back to True.
This diff changes that, so instead only users who are not found in the guild have in_guild set to False.
The bottleneck for this query is the number of users that are currently in_guild=False.
Testing locally, with 360k users off guild, this took 7.4s to query out, and 0.5s to process & 15.1 s to commit.
|
|
|
|
|
|
Bumps [ruff](https://github.com/astral-sh/ruff) from 0.4.9 to 0.5.0.
- [Release notes](https://github.com/astral-sh/ruff/releases)
- [Changelog](https://github.com/astral-sh/ruff/blob/main/CHANGELOG.md)
- [Commits](https://github.com/astral-sh/ruff/compare/v0.4.9...0.5.0)
---
updated-dependencies:
- dependency-name: ruff
dependency-type: direct:development
update-type: version-update:semver-minor
...
Signed-off-by: dependabot[bot] <[email protected]>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
|
|
|
|
|
|
|
Chris Lovering
dependabot[bot]