XenForo
Administrative
- Thread starter
- Admin
- #1
When trying to locate a user by email (used for GDPR removal requests), search takes a very, very long time and sometimes times out.
We have a large 12M+ member database.
It seems like the cause is that email search is using
Code:
Is it possible to refactor user search, so that if there is a single search parameter, such as username or email, that it uses an exact search instead of a LIKE? Or perhaps a switch like "Search exact username" to force that? I know...
Read more
ادامه مطلب...
We have a large 12M+ member database.
It seems like the cause is that email search is using
Code:
LIKE '%email%'Is it possible to refactor user search, so that if there is a single search parameter, such as username or email, that it uses an exact search instead of a LIKE? Or perhaps a switch like "Search exact username" to force that? I know...
Read more
ادامه مطلب...