CB

The check to see if a username or alias exists is too slow. With 1 million users this takes 4 seconds or more. Query as follows.

SELECT u.`id` FROM `jos_comprofiler` AS c INNER JOIN `jos_users` AS u ON u.`id` = c.`id` WHERE ( u.`username` = 'test' OR c.`alias` = 'test' ) LIMIT 0, 1

This becomes significantly faster (few milliseconds) if it's broken into 2 queries instead of a join. Needs further testing to find the most optimal query for checking this.

https://www.joomlapolis.com/forum/255-developer-members-support/242464-some-communiy-builder-running-which-does-not-clear#318292