RSS Feed/News Widget Newest Members might use inefficient query

[ENXF NET]

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.

Continue reading...