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

Increase database performance up to 5-10% and decrease memory

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Medium Medium
    • None
    • 4.2.0, 4.3.0, 4.4.0
    • Database related, Misc
    • None

    Description

      In eZ Publish it is quite common to always map integers as INT(11). This is bad database design. See the attached script for test and patch.You need to keep the key lengthz of all keys as short as possible. e.g. ezcontentobject.is_published should be 1 not 11. ezcontentobject.id should be 8 not 11 and so on. This pathc is quite important for larger databases.

      Attachments

        Activity

          People

            unknown unknown
            a7ccb6eb-752c-4f73-908e-4baabf343cdd@accounts.ibexa.co Björn Dieding
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: