Severe performance issues with Authlogic 3.2.0 #345

Open
mperham opened this Issue Feb 20, 2013 · 2 comments

Comments

Projects
None yet
3 participants

mperham commented Feb 20, 2013

Commit a889f9a changed the user lookup to use LOWER instead of LIKE. This is impossible to index in mysql so user lookup becomes a full table scan. We have millions of users so our production database went from <10% CPU to 300% CPU doing all of those scans.

pmarreck commented Apr 2, 2013

Has there been any update to this change?

The issue seems to be described well at
http://railsware.com/blog/2012/12/07/speeding-up-authlogic-login-for-postgres-and-mysql/

Owner

binarylogic commented Apr 4, 2013

Sorry, we're going to start managing this project better. How else could we do this? Going back to ILIKE is slow as well. I'm open to a pull request.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment