Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-69039

It's very slow to view single item after searching in database activity on moodle3.5.12

    XMLWordPrintable

    Details

    • Affected Branches:
      MOODLE_35_STABLE

      Description

      When I searched a category in the database activity ,it is fast to view a item of informations found on moodle 3.3.1(with php5.6.31 + mariad 10.1.25),but it is very slowly on moodle 3.5.12(with php 7.1.33,mariad 10.4.10).

      I found it is more slowly if the informations found is more ,and any operation become more slow after searching,it will even exceed 80 seconds to list items.But if restarting xampp ,it is normal again.Just searching the database activity will affect the performace of listing items or viewing single item.But no problem occurred on moodle3.3.1.I had tried on moodle3.6,the same problem occurred.

      I know moodle3.5 is written with php7,moodle3.3 with php5,is php7 more poor performace than php5?Or newer mariad is poor performace?I found there is a ibtmp1 file created by mariad10.4.10,but no ibtmp1 created by mariad10.1.25.

      Can anyone give advice?

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            jdwang jing-dong wang
            Participants:
            Component watchers:
            Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: