@mijustin @joshsmith Why not transform usernames to lowercase before saving them to the database? Then you don't need LOWER() in your query.
-
-
-
@kylefox would it make a difference? The expression is indexed, so I don't see why it's still so slow. - Show replies
New conversation -
-
-
@mijustin@joshsmith Unless you've setup your table with case sensitive columns then uniqueness: true should be enough.Thanks. Twitter will use this to make your timeline better. UndoUndo
-
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.
building