Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-5816

database out of memory error for LYBUNT, SYBUNT reports - use temp table for more efficient query

    Details

    • Type: Improvement
    • Status: Done/Fixed
    • Priority: Minor
    • Resolution: Fixed/Completed
    • Affects Version/s: 3.1.1
    • Fix Version/s: 3.1.3
    • Component/s: CiviReport
    • Labels:
      None

      Description

      In some environments, SYBUNT and LYBUNT reports result in database out of memory errors, so no report results are generated. One possibility to reduce the memory usage, which causes the reports work in my case, is to change the queries from using a subqueries to using temporary tables, instead.

      See the forum for details: http://forum.civicrm.org/index.php/topic,12098.0.html

        Attachments

          Activity

            People

            • Assignee:
              rahulbile Rahul Bile
              Reporter:
              kindermaur Kurt Indermaur
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: