Details
-
Improvement
-
Resolution: Obsolete
-
Medium
-
3.8.8
-
None
Description
Fetching user by mail or login generate mysql query that don't use index.
some thing like
select * from ezuser where LOWER(email)='XXX'
or
select * from ezuser where LOWER(login)='XXX'
LOWER should be remove from the query, so mysql will use index.
Login and email must be put in lower case before the are insert in the database so this code LOWER(login) wont be neccessary