http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6078
Chris Cormack <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch Status|Passed QA |Patch Pushed --- Comment #5 from Chris Cormack <[email protected]> 2011-08-10 09:14:38 UTC --- Original query results in an execution plan of +----+--------------------+------------+--------+-------------------------------+-------------------+---------+------+------+--------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+--------------------+------------+--------+-------------------------------+-------------------+---------+------+------+--------------------------+ | 1 | PRIMARY | borrowers | index | NULL | PRIMARY | 4 | NULL | 58 | Using where | | 2 | DEPENDENT SUBQUERY | <derived3> | system | NULL | NULL | NULL | NULL | 1 | | | 3 | DERIVED | old_issues | range | old_issuesborridx,old_bordate | old_issuesborridx | 5 | NULL | 8 | Using where; Using index | | 4 | UNION | issues | index | NULL | issuesborridx | 5 | NULL | 1 | Using index | | NULL | UNION RESULT | <union3,4> | ALL | NULL | NULL | NULL | NULL | NULL | | +----+--------------------+------------+--------+-------------------------------+-------------------+---------+------+------+--------------------------+ New query, is much better +----+--------------------+------------+-------+-------------------------------+-------------------+---------+-------------------------------+------+--------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+--------------------+------------+-------+-------------------------------+-------------------+---------+-------------------------------+------+--------------------------+ | 1 | PRIMARY | borrowers | index | NULL | PRIMARY | 4 | NULL | 58 | Using where | | 3 | DEPENDENT SUBQUERY | old_issues | ref | old_issuesborridx,old_bordate | old_issuesborridx | 5 | koha.borrowers.borrowernumber | 8 | Using where; Using index | | 2 | DEPENDENT SUBQUERY | issues | ref | issuesborridx,bordate | issuesborridx | 5 | koha.borrowers.borrowernumber | 1 | Using where; Using index | +----+--------------------+------------+-------+-------------------------------+-------------------+---------+-------------------------------+------+--------------------------+ Pushing, please test -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
