Re: [SR-Users] too long mysql table key

On 15.04.17 08:30, Juha Heinanen wrote:

Daniel-Constantin Mierla writes:

...

I haven't used this table myself, it's coming from SER branch, but I guess the unique constraint is for being sure there are no duplicated values for the same did/name tuple, but more records with same did and name.

lookup_domain() adds attributes associated with did to AVPs. Sure there can be more than one AVP with the same name. Therefore I suggest removing name and value from the index.

I am fine to drop this unique constraint if nobody else has a reason to keep it and eventually add some normal indexes that could help when loading/updating records in database.

Cheers, Daniel