Homec4science

When authentifying user-supplied email or nickname, use two SQL queries rather…

Authored by Tibor Simko <tibor.simko@cern.ch> on Nov 1 2006, 15:38.

Description

When authentifying user-supplied email or nickname, use two SQL queries rather than a single boolean OR query, for the latter one doesn't make use of indexes. This speeds up the authentication for large sites considerably, e.g. about three orders of magnitude for the CERN site.

Event Timeline

Tibor Simko <tibor.simko@cern.ch> committed R3600:7cbd91d4ea9b: When authentifying user-supplied email or nickname, use two SQL queries rather… (authored by Tibor Simko <tibor.simko@cern.ch>).Nov 1 2006, 15:38