400 Bad Request: TooManyIndexes?
The error says I have more than 32 indexes on a table when I only have 29?
2 Replies
There may be an off-by-one error in the limit, and i think the built-in indexes
by_id
and by_creation_time
count. I'll check the limit.
Can you describe your use-case that requires 29 indexes? That seems like a lot. If you want to index on more fields you could split out some fields into separate tables (like a "star schema") if a pattern like that fitsAh, just saw this, sorry about the delay.
I dont recall in detail, but the number of indexes are due to the number of permutations requred for a somewhat complicated filtering experience. And thanks for the suggestion, should I come across this same issue, I will certainly look into the pattern of creating additional tables