对医院数据库系统中SQL语句优化的探讨

Discussion on the Optimization of SQL Statements in the Hospital Database Systems

经过多年的信息化建设,我们医院变成了全面信息化的现代化医院。特别近两年来,医院信息系统(HIS)、实验室信息管理系统(LIS)以及影像归档和通信系统(PACS)系统的上线,大大增加了数据库的数据量,影像归档和通信系统(PACS)的图片传输对网络速度也提出了很高的要求。因此,SQL语句的优化就显得格外重要了。

After years of information construction,our hospital has become a comprehensive information technology of a modern hospital.Especially in the past two years,HIS,LIS and PACS system political line,greatly increased the amount of data of the database,and also made high demands on the PACS image transfer speed of the network.Therefore,the optimization of the SQL statement is particularly important.