zid
zid8mo ago

400 Bad Request: TooManyIndexes?

The error says I have more than 32 indexes on a table when I only have 29?
2 Replies
lee
lee8mo ago
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 fits
zid
zidOP8mo ago
Ah, 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

Did you find this page helpful?