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

Sql tweaks to reduce sql queries number per page.

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 3.10.0alpha1, 3.8.8, 3.9.2
    • Fix Version/s: 3.10.0beta1, 3.10.0rc1, 3.8.9, 3.9.3
    • Component/s: Caching
    • Labels:
      None

      Description

      Collection of patches to get down the database calls in ez publish.

      Primely focusing on removing repetitive sql calls and unnecessary calls currently.
      But there are plenty of those as I pointed out in yesterdays sdk mail about mysql performance, so more patches will come

      A small low down if you didn't read the mail:
      object with 50+ children and ~70 relations will generate around 900 sql calls in the admin interface when all details, relations, max children and so on is turned on.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                sp Sergiy Pushchin
                Reporter:
                sp Sergiy Pushchin
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: