Optimization design of prescription dispensing inquiry of No.1 Military Medical Project
10.7687/J.ISSN1003-8868.2015.09.063
- VernacularTitle:“军卫一号”医嘱摆药查询优化
- Author:
Youcun ZHU
;
Jianfa DUAN
- Publication Type:Journal Article
- Keywords:
SQL statement executive plan;
optimization of dispensing inquiry;
NO.1 Military Medical Project
- From:
Chinese Medical Equipment Journal
2015;(9):63-65,89
- CountryChina
- Language:Chinese
-
Abstract:
To realize rapid inquiry of the dispensing results in prescription dispensing subsystem. SQL statement tracer was used to determine corresponding SQL statement, and the executive plan was analyzed to find the desired table. Proper indexes were established to enhance the efficiency of the inquiry statement. The optimization of SQL statements made the executive efficiency increased greatly without the need for hardware upgrade. The analysis on the executive plan of the dispensing inquiry statements and the indexes on corresponding tables increases the prescription dispensing inquiry speed while decrease the waiting time of the staff.