Sybase数据库性能调优与客票系统

Optimizing performance of Sybase Database on Railway Ticketing and Reservation System

调优客票系统数据库的性能很重要。在SQL Server级的调优,有管理内存、锁、多引擎、设备、临时库和事务方面的内容;在数据库设计级,可以适当创建索引,必要时采用降范式设计;对于应用级,要充分利用索引,书写高效查询语句。

Optimizing database performance of Railway Ticketing and Reservation System was very important. At SQLServer management level, the methods included: manage memory, lock, engines, device, temporary database and transactionetc. At database design level, it should be created proper indexes, and adopt denormalization as occasion requires. At applicationdevelopment level, it must be paid attention to write efficient SQL and taken full advantage of indexes.