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

Reply via email to