Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-6691

Change the mapping of the event requestId field to varchar(48)

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Major
    • 4.3-milestone-1
    • 3.1 RC1
    • Event Stream
    • None
    • Medium
    • N/A
    • N/A

    Description

      This is better for two reasons:

      • VARCHAR(48) is faster than the current TEXT
      • TEXT columns can't be automatically indexed

      This is possible since we're only storing a fixed-length GUID in that field, we never used something longer than what fits in a varchar column.

      Attachments

        Issue Links

          blocks

          Improvement - An improvement or enhancement to an existing feature or task. XWIKI-7498 Auto-create index on the groupId column of the activity/event stream table

          • Major - Major loss of function.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. XWIKI-7124 Missing index in activity stream causes slow activity stream

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. XWIKI-8484 Migration from a 2.7.2 to 4.3-RC1 fails on MySQL

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            People

              sdumitriu Sergiu Dumitriu
              sdumitriu Sergiu Dumitriu
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: