Minimize result set size  Minimize use of two-phase commit

Chapter 6: Database Access Tuning

Use database server optimizations

Tune your queries to minimize database response time. Take advantage of any performance features available in your database, such as stored procedures if using Sybase Adaptive Server Enterprise. Consult your database performance and tuning documentation. If you are using Sybase Adaptive Server Enterprise, the Performance and Tuning Guide is available on the Sybase Product Manuals Web site.





Copyright © 2005. Sybase Inc. All rights reserved. Minimize use of two-phase commit

View this book as PDF