The entity selector has a new method set_optimize which currently can be used to specify a straight join (set_optimize('straight_join')). The add right and add left relationship field methods have also been changed slightly to handle add_table('allowable_relationship') after add_table('relatoinship'), which improves the speed of some straight_join queries across sites.
The calendar.php class now uses the set_optimize('straight_join') method to improve the speed of selecting events across sites. Additional work is needed to improve the speed of the reason sharing / borrowing functionality.
Files Modified
- classes/entity_selector.php
- carl_util/db/db_selector.php
- classes/calendar.php