摘要
在数据库和应用程序设计等方面探讨了信息查询的性能问题,研究了基于Web方式数据查询的优化方法.在高校财务信息查询系统的设计中,通过物理数据库的优化设计、使用优化的SQL语句、使用存储过程和基于存储过程的分页显示技术等优化信息查询性能,并给出了具体的代码实现,从而在软件方面解决了信息查询系统的性能问题.
This paper discusses the performance problem in information query in database and program design. It presents performance optimization methods of querying data based on Web. In designing querying information systems in university finance, it designs performance optimization methods through constructing physics data- base, using SQL and stored procedure, and by adopting paging technique in a stored procedure. Moreover, material code implementation is given. Accordingly, it solves the performance optimization problem of information query in terms of software.
出处
《中国计量学院学报》
2006年第3期233-237,共5页
Journal of China Jiliang University
关键词
高校财务
信息查询
性能优化
university finance affairs
information query
performance optimization
