[Cubicweb] unique constraint on unlimited String attribute
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...
Size: 819 bytes
Desc: OpenPGP digital signature
More information about the Cubicweb