Hi I am new to Cassandra and using DataStax Astra DB on AWS. Problem I am facing is for each table we have different where clauses for different columns hence the modelling was done based upon the queries, (meaning multiple tables with same data but different clustering columns for query support.). This approach was working great till we reached 200 tables per keyspace guardrail limitation. One solution was to use SAI indexes however there is a limitation that I cant create more than 100 index per keyspace per cluster. What is the solution ?
2 Answers
I am curious as to why so many tables are needed and are they really all for the same application? Each application or service should have its own keyspace, so that 200 table limit shouldn't usually be a problem.
What you'll probably want to do is to create a new keyspace. That will allow you to create more tables.
I agree with Aaron about 200 tables rarely being an issue but in addition to his answer, 200 is a soft limit that works in almost all cases.
To the uninitiated, more than 200 tables seems excessive but it's hard to know without getting to know your use case a bit deeper.
I'm reluctant to recommend you request for the limit to be increased without having intimate knowledge of your environment so I would suggest you reach out to them and request to be put in touch with one of the architects to discuss your requirements. Cheers!
Related