Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-20194

Merge performance optimization branch from Qafoo

    XMLWordPrintable

Details

    • Stetind Sprint 1, Stetind Sprint 3, Stetind Sprint 4
    • 2

    Description

      From QaFoo:

      The current status of the performance optimizations is roughly
      summarized at:

      https://github.com/ezsystems/research/blob/master/performance/docs/optimizing_status.txt

      Verdict: Performance already almost increased by factor 8.

      There are several related code changes in the ezp-next/performance
      branch.

      Most important changes:

      • Caching languages and content types
      • Optimizing identifier quoting
      • Adding missing indexes
      • Small query optimizations

      By now MySQL is clearly the bottle neck, without any other remaining low
      hanging fruits. And every query, which is executed more then once,
      properly uses indexes. Reducing indexes to the minimal required set will
      probably help with the insert performance.

      Considerations:

      Added indexes needs to be reflected in legacy as well so we should not add indexes without also trying to remove some, there are already duplicates, lets not have even more of that.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              christian.bacher-obsolete@ez.no Christian Bacher (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 2 days Original Estimate - 2 days
                  2d
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 3 days, 4 hours, 30 minutes
                  3d 4h 30m