Fixed Widget Newest Members might use inefficient query

K

Kirby

Well-known member
Affected version
2.2.13
PHP: 
$userFinder = $this->finder('XF:User')
    ->isValidUser()
    ->order('register_date', 'DESC')
    ->limit($this->options['limit']);

This sometimes picks index user_state / is_banned_user_state which is inefficient - ddding an index hint for register_date seems to fix this.
 
Thank you for reporting this issue, it has now been resolved. We are aiming to include any changes that have been made in a future XF release (2.2.16).

Change log:
Add an index hint to the newest members widget
Click to expand...
There may be a delay before changes are rolled out to the XenForo Community.
 
Back
Top Bottom