Contents Index Reduce the number of requests between client and server Reduce primary key width

ASA SQL User's Guide
  Monitoring and Improving Performance
    Top performance tips

Reduce table widths


Tables with a large number of columns are known as wide tables. When the number of columns in a table causes the size of individual rows to exceed the database page size, each row is split across two or more database pages. The more pages a row takes up, the longer it takes to read each row. If you find performance lacking, and you know you have tables with many columns, consider normalizing your tables to reduce the number of columns. If that is not possible, a larger database page size may be helpful, especially if most tables are wide.


Contents Index Reduce the number of requests between client and server Reduce primary key width