基于SQL Server的数据库应用系统性能的优化

摘要

结合基于SQL Server6.5+PowerBuilder6.0开发环境的实践经验,从数据库设计、查询结构、并行处理、客户/服务器模式、应用编程等方面讨论了数据库应用系统性能优化的一些原则、方法和问题。%This paper discusses the principles,methods and some problems about database design,query structure,parallel transaction,Client/Server and programming in performance optimization of SQL Server-based database applications,combining with the author＇s own experiences in developing such applications.