Tenant Based Indexing
A true Multi tenant SaaS application uses shared database with shared schema to achieve better cost efficiency and maintainability. But over a period of time when the application grows with 100s, or 1000s of tenants, the data stored in the database might also grow exponentially, due to which the application’s performance (while fetching the data) may slow down. Indexing the data might be a good option to improve the speed but it is also resource intensive. So what can we do to enhance the performance?
