Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-12306

topic and post IDs columns should be larger

    XMLWordPrintable

Details

    Description

      The topic_id and post_id fields are specified as UINT in the schema file, this results in a mediumint(8) unsigned in MySQL. This is too small for very large forums. Our forum surpasses 18million posts, while mediumint would cap out at 16m.

      With current hardware there is really no good reason to use mediumint(8) over int(10), the amount of space saved is negligible for the majority of use cases.

      Attachments

        Issue Links

          Activity

            People

              bantu Andreas Fischer [X] (Inactive)
              joelk2 joelk2 [X] (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: