医疗卫生装备
醫療衛生裝備
의료위생장비
Chinese Medical Equipment Journal
2015年
9期
63-65,89
,共4页
SQL语句执行计划%摆药查询优化%军卫一号
SQL語句執行計劃%襬藥查詢優化%軍衛一號
SQL어구집행계화%파약사순우화%군위일호
SQL statement executive plan%optimization of dispensing inquiry%NO.1 Military Medical Project
目的:实现医嘱摆药子系统摆药结果查询快速高效。方法:使用SQL语句跟踪工具查找相关SQL语句,分析查看SQL语句执行计划,找出引起执行全表扫描的表,通过建立合适的索引提高查询语句的查询效率。结果:在不升级硬件的条件下对SQL语句进行优化,使得与医嘱摆药查询相关的2条SQL语句的执行效率得到了大幅提升。结论:通过对医嘱摆药子系统摆药结果查询语句执行计划的分析,在相关表建立适当索引,可大大提高医嘱摆药查询速度、缩短摆药人员等待时间。
目的:實現醫囑襬藥子繫統襬藥結果查詢快速高效。方法:使用SQL語句跟蹤工具查找相關SQL語句,分析查看SQL語句執行計劃,找齣引起執行全錶掃描的錶,通過建立閤適的索引提高查詢語句的查詢效率。結果:在不升級硬件的條件下對SQL語句進行優化,使得與醫囑襬藥查詢相關的2條SQL語句的執行效率得到瞭大幅提升。結論:通過對醫囑襬藥子繫統襬藥結果查詢語句執行計劃的分析,在相關錶建立適噹索引,可大大提高醫囑襬藥查詢速度、縮短襬藥人員等待時間。
목적:실현의촉파약자계통파약결과사순쾌속고효。방법:사용SQL어구근종공구사조상관SQL어구,분석사간SQL어구집행계화,조출인기집행전표소묘적표,통과건립합괄적색인제고사순어구적사순효솔。결과:재불승급경건적조건하대SQL어구진행우화,사득여의촉파약사순상관적2조SQL어구적집행효솔득도료대폭제승。결론:통과대의촉파약자계통파약결과사순어구집행계화적분석,재상관표건립괄당색인,가대대제고의촉파약사순속도、축단파약인원등대시간。
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.