CB

With a million user rows the queries for a userlist are noticeable slow. Taking several seconds or not loading at all. This is mostly due to the DISTINCT usage, which isn't necessary for frontend userlist (and if needed it's faster to use GROUP BY). Few minor issues with WHERE statement order being incorrect in some cases as well causing indexes to have a hard time being utilized.