05-18-2020, 08:21 PM
Hi Sid,
No queries can be made to a key that contains an array. It would be cool to be able to do that. It would have a negative hit on the performance of the query. You laid at the pros and cons very well.
If you wanted to embrace storing full arrays in a single key, you could store meta data on a separate table that you linked to the full array in another table. You could query the meta data and have a key that stored the recordID to the full array in the other table. This could give you a working solution.
No queries can be made to a key that contains an array. It would be cool to be able to do that. It would have a negative hit on the performance of the query. You laid at the pros and cons very well.
If you wanted to embrace storing full arrays in a single key, you could store meta data on a separate table that you linked to the full array in another table. You could query the meta data and have a key that stored the recordID to the full array in the other table. This could give you a working solution.