- πΊπΈUnited States wylbur Minneapolis, Minnesota, USA
Closing this as Outdated as Drupal 7 is EOL.
The query in redirect_fetch_rids_by_path() cannot use and index to match the source, but this is extremely slow for sites with a large "redirect" table. Even with an index, a case-insensitive LIKE would be slow on non-MySQL databases.
Here is my suggested fix (which is portable to non-MySQL and still fast):
You could also coerce to uppercase. Either would work.
A quick fix, which would at least make things on MySQL with case-insensitive indexes (the Drupal+MySQL default) fast, would be to create an index on (source, language).
Closed: outdated
Code
It affects performance. It is often combined with the Needs profiling tag.
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
Closing this as Outdated as Drupal 7 is EOL.