Max column value for multivalued key

HCL Domino Domino Forum
1

Good Morning,

I have question on the maximum number of columns that can be looked up with an array of keys for a GetAllDocumentsByKey method. Is their a max value?

thanks for any help!

stephen

2

Subject: RE: max column value for multivalued key

I don’t know of a specific limit, but your question makes me nervous. From a performance and space usage standpoint, long before you reach that limit, you will reach the point where it makes more sense to use fewer keys and sort thru the results, rather than have – let’s say – 100 sorted columns in your view. View column sorts are not free.

3

Subject: RE: max column value for multivalued key

thanks for the response!

I’ve decided to go different route, i have set my column in my view to 3 form values and concatenated them.

no need to be nervous, I was trying to use a key of arrays for 5 columns, but browsing the forum i saw someone ask if there was a limit, and they asked if it was 3, so when I thought I needed 5 i got worried, and no one had responded to his question about whether 3 was the max value, but thanks for clearing it up, I will store it for future reference.