This design increases the number of tables significantly over adding a database instance per customer or creating a column in each table to validate whether the customer is accessing the proper data.
在为每个客户添加数据库实例时,或者在每个表中创建一个数据列以验证客户是否访问合适的数据时,这种设计会大大增加表的数量。
Suppose a table in an OLTP database already has 6 or 7 indexes. Would I give a thumbs-up to adding another?
假设 OLTP 数据库中的一个表已经拥有 6 个或 7 个索引,我还会赞成再添加一个吗?
Tuning might mean adding memory to a starved system, modifying operating system parameters, hastening the Web or database server, rewriting code for efficiency, or some combination thereof.
调优意味着对系统增加内存、修改操作系统参数、加速Web或数据库服务器、提高代码效率或者这其中的一些组合。
应用推荐