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

CiviMail report extremely slow

          Details

          • Type: Bug
          • Status: Done/Fixed
          • Priority: Major
          • Resolution: Won't Fix
          • Affects Version/s: 3.4.4
          • Fix Version/s: 4.4.0
          • Component/s: CiviMail
          • Labels:
            None

            Description

            We're running a mailing to 41k recipients.

            While the mailing is still running, the url http://hostname/civicrm/mailing/report takes
            about 2 minutes to generate the report. If I enable SQL logging, I see thousands of
            queries "SELECT COUNT(...) FROM ...(5 tables joined together)...".

            Moreover, the mailing proceeds extremely slowly and requires more than 1.5GB of memory
            (the memory limit in php.ini needs to be raised to 512MB).

            The host is running Ubuntu Lucid with all updates. I tried enabling memcached and APC and dump/restore the mysql database, but the situation did not improve.

              Attachments

                Activity

                  People

                  • Assignee:
                    xcf33 Chang Xiao
                    Reporter:
                    bernie Bernie Innocenti
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    1 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: