Re: Optimizing query with joins
Posted by:
Rob Blick
Date: June 07, 2006 10:17AM
The first thing that jumps out at me are your LIKE '%blah%' clauses. Those kill you, because no index can help (LIKE 'blah%' will benefit, but not LIKE '%blah%'). MySQL is doing table scans on your civicrm_contact and civicrm_email tables. If those are MyISAM tables, you may be able to garner some help from fulltext indexes (though you'll need to rewrite the query to use MATCH... AGAINST).
Subject
Views
Written By
Posted
3277
June 03, 2006 12:18PM
Re: Optimizing query with joins
2045
June 07, 2006 10:17AM
2038
February 12, 2007 12:07PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.