论文部分内容阅读
以数据库SQLSERVER为例,提出了一些优化C/S环境下的信息系统的措施:根据实际情况选择适当的数据库规范级别、合理规划数据库的数据关系及类型、以少量冗余换取系统性能等方法优化数据字典,确定在适当对象上建立索引和选择适当的索引类型等方法优化索引,通过限制查询结果集、减少查询必须连接的表的数目、编写和调用存储过程等方法优化查询,通过缩短事务、编写调用数据库触发器等方法提高系统性能和可靠性
Taking the database SQLSERVER as an example, some measures to optimize the information system in C / S environment are put forward: selecting the appropriate database specification level according to the actual situation, reasonably planning the data relation and type of the database, optimizing the system performance with a small amount of redundancy Data dictionary, to determine the appropriate objects in the index and select the appropriate index type optimization index, by limiting the query result set to reduce the number of tables the query must be connected to write and call stored procedures and other methods to optimize the query, by shortening the transaction, Write calls to database triggers and other methods to improve system performance and reliability