[Cubicweb] unique constraint on unlimited String attribute

Florent Cayré florent.cayre at logilab.fr
Fri Jun 17 12:04:55 CEST 2016


On 06/16/16 15:03, Julien Cristau wrote:
> Indices on unlimited string columns are not supported by sql server, at
> least, and in general it seems questionable from a design and
> performance pov to want to search on such a field (except using full
> text search).

Sylvain mentions UNIQUE, often intended for data integration purpose,
not for search. IMHO, database engines should be able to support
uniqueness using hash functions, no matter the string size.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: OpenPGP digital signature
URL: <http://lists.cubicweb.org/pipermail/cubicweb/attachments/20160617/9322d1a8/attachment-0252.sig>


More information about the Cubicweb mailing list