Eliminate unnecessary join to civicrm_financial_type table to improve performance
authoreileen <emcnaughton@wikimedia.org>
Thu, 28 Feb 2019 03:55:21 +0000 (16:55 +1300)
committereileen <emcnaughton@wikimedia.org>
Mon, 4 Mar 2019 22:09:10 +0000 (11:09 +1300)
commit124f3c1b17c5465b55a0c57230e0c0cc95f5ddba
tree2606aea4a39906a398ca09eceb0944e0f8d36375
parent4fc150ab6eb53cca6b9a42cd094a7ff28dac725a
Eliminate unnecessary join to civicrm_financial_type table to improve performance

Although this join is indexed it affects index choice, often causing the right index not to
be used and slowing performance. I got subtantial speed improvement by eliminating this join
CRM/Contact/BAO/Query.php
CRM/Contribute/BAO/Query.php
tests/phpunit/CRM/Contribute/BAO/QueryTest.php
tests/phpunit/CRM/Export/BAO/ExportTest.php