Revenge of password_policy_update_8302 takes too long for a large amount of users

Created on 6 December 2022, over 2 years ago
Updated 7 April 2024, about 1 year ago

This is a follow up to https://www.drupal.org/node/3258563 β†’

I have rearranged the code a bit and moved the SQL-approach into the first if entirely. There is no need to batch this at all.

On one of our sites with ~65k users, this update step took many minutes to complete.

Using an INSERT INTO...SELECT approach, it takes milliseconds.

Let me know if there are any changes you'd like me to make to this.

✨ Feature request
Status

Postponed: needs info

Version

3.1

Component

Code

Created by

πŸ‡¬πŸ‡§United Kingdom nicholasthompson

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.

  • πŸ‡ͺπŸ‡ΈSpain guardiola86

    I can see this is now included in 4.0.x with some changes

  • Issue was unassigned.
  • Status changed to Postponed: needs info about 1 year ago
  • πŸ‡ΊπŸ‡ΈUnited States Kristen Pol Santa Cruz, CA, USA

    Thanks to everyone for the work on this issue.

    I'm going through all the 8.x issues.

    As the 8.x is no longer supported, I'm postponing this issue for now and need feedback as to whether or not this issue is relevant to 4.0.x.

    If it is, please reopen and change the version, make sure the issue summary is clear and complete, including steps to reproduce, and reroll the patch. If it's not, please close.

    If there is no response to this in a month addressing the above, it can be closed.

Production build 0.71.5 2024