- تاریخ ثبتنام
- 2020-06-26
- نوشتهها
- 21,417
- راهحلها
- 27
- پسندها
- 3,264
- امتیازها
- 113
- سن
- 27
- محل سکونت
- England
- وب سایت
- xenforo.xyz
getIpsByUser effectively uses the following query:
SQL:
Although it looks complicated, this can be optimized quite a bit by an index on
SQL:
Although it looks complicated, this can be optimized quite a bit by an index on
(user_id, ip, log_date DESC). It's not a , but it should be good enough for all but the largest forums. Larger forums may be able to get better...