I have a problem while search members, its very slow it take 17sec with default elgg 2.1.1.
I am using profile manage with 15 fields and the user is more than 30K. But all other(object , tags) search good and it comes within...
@RVR Thanks for you reply.
I am running two elgg.
One is elgg1.7[its in root] that is live. And second one is elgg1.11[domain.com/elgglatest].
If i given root path to elgglatest, its works fine. but i dont want to disturb... view reply
I want search a string in elgg_users_entity and elgg_metadata tables. Please check the sql what i have written. But it take lot of time. Is it right?
SELECT DISTINCT * FROM elgg_entities e
JOIN elgg_metadata md...