Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Minor
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.6.8
-
Fix Version/s: 4.7
-
Component/s: CiviReport
-
Labels:None
-
Documentation Required?:None
-
Funding Source:Contributed Code
Description
The Membership Contribution Details report's "statistics" SQL chokes on modest data sets because the temporary table created by the report is unindexed. With a temporary table with 56K records, I had to kill my MySQL query after 10 minutes with no luck. Indexing the temporary table added .3 seconds to the insert, and the statistics computed in a fraction of a second.