On Sun, Apr 3, 2016 at 4:32 PM, Peter Huisman <p.huisman@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@xwiki.org http://lists.xwiki.org/mailman/listinfo/users