daledotshan/liferay-portal — pull request #64 by yuhai (2014-08-13 09:09:42+00:00)
Title: LPS-49276 My Sites portlet takes a long time to render

The issue occured in userIds.addAll(countByC_FN_MN_LN_SN_EA_S(session, companyId, firstNames, middleNames, lastNames,screenNames, emailAddresses, status, params1, andOperator)) ;(it will cost some time when add list into set).

Due to the members will include explicit users (assign user to site directly) and implicit users(assign user to org and then assign org to site). One user might belong to explicit user and implicit user simultaneously. So the origin logic is by using set will remove the reproduced data(the user belong to explicit user and implicit user) when add list into set.

Refer to findByC_FN_MN_LN_SN_EA_S method in UserFinderImpl.java, we can use "UNION" in sql grammar instead of using "userIds.addAll".