On Sun, Apr 3, 2016 at 4:32 PM, Peter Huisman <p.huisman(a)ximm.nl> wrote:
Hi,
A few short questions:
What is the storage limit when NOT using Relational Storage for each
selected item? - I assume this is 255 but I’m not sure.
What is the storage limit when NOT using Relational Storage for all
selected items in total? - I do not know what to make of this.
I think the quote you pasted is pretty clear: if you're not using
Relational Storage then all the selected items (values) are saved in the
same VARCHAR field which is limited, normally, to 255 characters. So
there's no per-selected-item limit but only for-all-selected-items limit
(i.e. for the concatenation).
Hope this helps,
Marius
The only reference I could find is a quote in an XWiki-devs mail in 2011:
Make sure you select the Multiple Select and
Relational Storage
checkboxes. Multiple Select allows you to select and store multiple
values from the list, while Relational Storage makes it easier to
integrate that property into other queries by storing each selected item
in its own entry in the database (without it all the selected values are
stored in one row, concatenated into a VARCHAR column), and to store
more than a few selected values (since the column allows at most 255
characters in total).
With kind regards,
Peter
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users