This is a patch we're maintaining internally right now.
- LOWER() is a performance killer on large scale Drupal sites
- We also need to expose passwords as a token for emailing people a password

(I'm sure the maintainer would probably like to have this rerolled into two patches. I'll try and do that soon. I figured better to get it up sooner rather than later though.)

Comments

bryanhirsch’s picture

StatusFileSize
new3.41 KB

patch attached

bryanhirsch’s picture

StatusFileSize
new2.47 KB

Re-rolled patch attached. This one only removes LOWER() functions.

Password/token issues are being addressed here:
http://drupal.org/node/1165126

jwhat’s picture

Agreed, never use LOWER() in MySQL, terrible for performance.

torgospizza’s picture

Issue summary: View changes
Status: Active » Reviewed & tested by the community
torgospizza’s picture

Status: Reviewed & tested by the community » Active

Whoops, hit the wrong dropdown.