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

Field types declaration should be more relevant

    XMLWordPrintable

Details

    • Icon: Improvement Improvement
    • Resolution: Obsolete
    • Icon: Medium Medium
    • None
    • 4.2.0alpha1, 4.2.0beta1, 4.2.0rc1, 4.2.0rc2
    • Database related
    • None

    Description

      Hi spent a few hours trying to fix our table fields declaration for MySQL.
      The problem is that we use INT(11) too much even for storing 1 digit values for example.

      I updated the field declaration and provided the SQL script for this as an attachment.

      This new schema is currently being tested on high volume data and on preproduction.

      More informations about that as soon as possible.

      Attachments

        1. benchmark2.png
          benchmark2.png
          86 kB
        2. bug15534.png
          bug15534.png
          68 kB
        3. fixedtabletypes.sql
          7 kB
        4. fixedtabletypes.sql
          7 kB
        5. query.sql.gz
          0.2 kB
        6. query.sql.gz
          0.5 kB

        Activity

          People

            unknown unknown
            qwix qwix
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated: