Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-1276

Downloading csv response of 700 answers costs 13,250 database queries

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Fix
    • Icon: Minor Minor
    • None
    • 1.9.4
    • Module: Questionnaire
    • None
    • MOODLE_19_STABLE

      This makes it unsuable on our servers.

      A relevance performance log:
      [Tue May 12 10:00:08 2009] [error] [client 192.168.254.2] PERF: /mod/questionnaire/report.php?instance=4&sid=14&action=dcsv time: 9.330567s memory_total: 18108944B (17.3MB) memory_growth: 17676856B (16.9MB) memory_peak: 18747732B (17.9MB) includecount: 34 dbqueries: 13250 ticks: 933 user: 760 sys: 37 cuser: 0 csys: 0 serverload: 0.17 rcache: 833/733 , referer: http://moodle.cream/mod/questionnaire/report.php?instance=4&sid=14&action=vall

        1. 0001-When-exporting-from-response_multiple-quesitons-in-C.patch
          4 kB
        2. 0001-CONTRIB-1276-ugly-database-query-optimisaiton.patch
          6 kB
        3. final.patch
          11 kB

            mchurch Mike Churchward
            poltawski Dan Poltawski
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.