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

topic and post IDs columns should be larger

    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

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

                Dates

                • Created:
                  Updated:
                  Resolved: