Uploaded image for project: 'eXo-JCR'
  1. eXo-JCR
  2. EXOJCR-1511

Improve the performances of the query corresponding to getChildNodesDataByPage

    Details

      Description

      I enabled the statistics and launched the unit tests on my local machine using mysql at then end of the tests, I checked the csv file and could notice that the average time for getChildNodesDataByPage was about 15 ms and the average time for getChildNodesData was about 1,2 ms. However I must admit that 15 ms was an average time on 28 queries which is not representative enough so the goal of this task will be to launch the tests from GetNodes_nonIterating_smallSet to GetNodesLazily_Iterating_1000_hugeSet with the cache disabled and the statistics enabled on all db types and improve the query if needed.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                nzamosenchuk Nikolazy Zamosenchuk
                Reporter:
                nfilotto Nicolas Filotto
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 1 week Original Estimate - 1 week
                  1w
                  Remaining:
                  Time Spent - 2 days Remaining Estimate - 1 week
                  1w
                  Logged:
                  Time Spent - 2 days Remaining Estimate - 1 week
                  2d