Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.3.5
    • Fix Version/s: 2.4, 2.3.6
    • Component/s: Tool Forum
    • Labels:
      None

      Description

      Since LDEV-963 was implemented, the forum performance has decreased dramatically.

      We've got to look at more efficient ways to run these queries so Forum can run as quick as it used to.

        Activity

        ernieg Ernie Ghiglione created issue -
        Hide
        dronych Andrey Balan added a comment -
        done
        Show
        dronych Andrey Balan added a comment - done
        dronych Andrey Balan made changes -
        Field Original Value New Value
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Hide
        ernieg Ernie Ghiglione added a comment -
        Hmmm... Andrey, I ran the testharness attached with a sequence 10forums.zip and with different number of users and here are the results.

        Original 2.3.5 release tag (previous to this improvements:

        30 learner(s) attended, 30 finished and 0 aborted.
        Total response time: 498.541 seconds (8.309016666666666 minutes)
        Average response time: 0.20903186582809224 seconds

        40 learner(s) attended, 40 finished and 0 aborted.
        Total response time: 925.381 seconds (15.423016666666665 minutes)
        Average response time: 0.2913668136020151 seconds

        50 learner(s) attended, 49 finished and 1 aborted.
        Total response time: 1709.173 seconds (28.486216666666667 minutes)
        Average response time: 0.43903750321089136 seconds

        60 learner(s) attended, 58 finished and 2 aborted.
        Total response time: 3661.918 seconds (61.03196666666667 minutes)
        Average response time: 0.7799612353567625 seconds

        Now, with these changes I get:

        30 learner(s) attended, 30 finished and 0 aborted.
        Total response time: 583.97 seconds (9.732833333333334 minutes)
        Average response time: 0.2448511530398323 seconds

        40 learner(s) attended, 40 finished and 0 aborted.
        Total response time: 1031.258 seconds (17.187633333333334 minutes)
        Average response time: 0.3248056692913386 seconds

        50 learner(s) attended, 50 finished and 0 aborted.
        Total response time: 2207.049 seconds (36.78415 minutes)
        Average response time: 0.5564924357034796 seconds

        60 learner(s) attended, 60 finished and 0 aborted.
        Total response time: 3901.229 seconds (65.02048333333333 minutes)
        Average response time: 0.8202752312867956 seconds


        So it's taking more time now than it was before :-(

        Of course Im using the same desktop for both. For 2.3.5, I checked out the lams2_3_5 tag from CVS, compile and run the test harness against it. Then I check out lams2_3_release branch and run the same test harness. So it's pretty much exactly the same.

        Show
        ernieg Ernie Ghiglione added a comment - Hmmm... Andrey, I ran the testharness attached with a sequence 10forums.zip and with different number of users and here are the results. Original 2.3.5 release tag (previous to this improvements: 30 learner(s) attended, 30 finished and 0 aborted. Total response time: 498.541 seconds (8.309016666666666 minutes) Average response time: 0.20903186582809224 seconds 40 learner(s) attended, 40 finished and 0 aborted. Total response time: 925.381 seconds (15.423016666666665 minutes) Average response time: 0.2913668136020151 seconds 50 learner(s) attended, 49 finished and 1 aborted. Total response time: 1709.173 seconds (28.486216666666667 minutes) Average response time: 0.43903750321089136 seconds 60 learner(s) attended, 58 finished and 2 aborted. Total response time: 3661.918 seconds (61.03196666666667 minutes) Average response time: 0.7799612353567625 seconds Now, with these changes I get: 30 learner(s) attended, 30 finished and 0 aborted. Total response time: 583.97 seconds (9.732833333333334 minutes) Average response time: 0.2448511530398323 seconds 40 learner(s) attended, 40 finished and 0 aborted. Total response time: 1031.258 seconds (17.187633333333334 minutes) Average response time: 0.3248056692913386 seconds 50 learner(s) attended, 50 finished and 0 aborted. Total response time: 2207.049 seconds (36.78415 minutes) Average response time: 0.5564924357034796 seconds 60 learner(s) attended, 60 finished and 0 aborted. Total response time: 3901.229 seconds (65.02048333333333 minutes) Average response time: 0.8202752312867956 seconds So it's taking more time now than it was before :-( Of course Im using the same desktop for both. For 2.3.5, I checked out the lams2_3_5 tag from CVS, compile and run the test harness against it. Then I check out lams2_3_release branch and run the same test harness. So it's pretty much exactly the same.
        Hide
        ernieg Ernie Ghiglione added a comment -
        Zip.zip is the test harness I'm running so you can have the same configuration if you need to test in your end
        Show
        ernieg Ernie Ghiglione added a comment - Zip.zip is the test harness I'm running so you can have the same configuration if you need to test in your end
        ernieg Ernie Ghiglione made changes -
        Attachment zip.zip [ 12059 ]
        Hide
        ernieg Ernie Ghiglione added a comment -
        Tested and closed
        Show
        ernieg Ernie Ghiglione added a comment - Tested and closed
        ernieg Ernie Ghiglione made changes -
        Status Resolved [ 5 ] Closed [ 6 ]

          People

          • Assignee:
            dronych Andrey Balan
            Reporter:
            ernieg Ernie Ghiglione
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development