Increase the size of all the document reference related database columns

Development
1

Hi devs,

A first safe (from retro compatibility point of view) step for improving the limit regarding the maximum size of the references in XWiki (currently 255 characters) could be to increase the cause of this limitation: the size of the columns in the database which store document references.

Long story short with the currently supported databases we can increase it to 768 characters without impacting noticeably the performances (of course bigger references will take more disk space but for example in supported versions of MySQL the storage is variable, and you don’t get the maximum size allocated all the time).

See https://design.xwiki.org/xwiki/bin/view/Proposal/Increasethe255characterslimitforreferences#HIncreasethesizeofthereferencerelatedfields for more technical details that leaded to 768. It also contains very first thoughts on other ideas to help workaround this limitation.

So I propose to do the following:

Of course 768 is still not huge, and I don’t see it as the final solution to close this subject for good, but it’s already a nice improvement that we can have in the next version of XWiki without taking much risk.

WDYT ?

2

+1

Thanks,
Marius

3

+1

4

+1, Thanks

5

+0 for 2 reasons:

  • 768 is still low and we’ll still have some problems
  • a migration is never simple and there are often edge cases or it takes long for large XWiki instances to migrate. In short, it’s not seamless and there are lots and lots of columns to modify here. So I would feel more comfortable if we decide what we want to do in the future first to have a target direction. Imagine if we find a different solution in not long and we have to do again another migration. It’s a bit painful and risky.

So I don’t want to block anything but a proposal/vote about the future would be nice.

2 notes: