Asset performance with custom tags

[evasv]

Spoon, I need to know the above before I start re-tagging my collection.

[Spoon]

The way multi values work in the table it is internally indexed to a value, even unknown values, so the space it takes up will be the same, tag there or not.

[evasv]

I see. So this is how I believe the index works, can you confirm:

a) Custom tags: If I index a tag, Asset will allocate space/values for my whole collection of 5000 albums, even if I tag only 1 or even zero albums?

b) Multiple values: Setting "t_tagname,3,INTEGER" means that Asset will allocate space/values for 4 multiple values for my whole collection, even if I tag only 1 single value in 1 album?

[Spoon]

Correct