Actually around 5.000 tenants. Based on kind of application number of tenants in the worst scenario can reach 10.000.

Scope of application is related only to a very specific kind of...

Hi @ratbak thanks for response.

Yes about tipology of application i will never never never exceed 1 milion rows, also because i have a retention of 4-5 years, than i can...

Hi @desnorton, the other option is to have PK (TenantId,Id) in each table, but in many table i have always filter by year, so i believe it could...

Yes all Is segregated by single tenant

Hi, the scenario most of the times is:

1)Loading data in a grid (by tenant,year)

2)user perform update on some rows, update by id