- تاریخ ثبتنام
- 2020-06-26
- نوشتهها
- 21,420
- راهحلها
- 27
- پسندها
- 3,264
- امتیازها
- 113
- سن
- 27
- محل سکونت
- England
- وب سایت
- xenforo.xyz
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...
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...
نام موضوع : Search by Email - Slow on Large User Database
