Separate BC company tables in the database by schema instead of having them all in dbo
Business Central (and way back to Navision) stores all tables for all ERP companies in the one database and in the one schema (dbo). So, if you have (say) 18 companies and each has 3.6K tables, suddenly you have 66K tables all in the dbo schema in one database.
This is a nuisa...
Category: Development (1070)