because of a MySQL bug still active in almost all servers the search from SugarCRM becomes very slow or even times out for big databases/tables when “Any email” field is involved.
Solving this bug improves the speed of search considerably , allowing users to use this search for databases with a big number of records too , and decreasing server load considerably.
Part that needs fixed
leads.id IN (SELECT eabr.bean_id FROM email_addr_bean_rel eabr JOIN email_addresses ea ON (ea.id = eabr.email_address_id) WHERE eabr.deleted=0 AND ea.email_address LIKE
Please contact us for more information.