Contents Index Use AUTOINCREMENT to create primary keys Minimize cascading referential actions

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

Replace expensive triggers


Evaluate the use of triggers to see if some of the triggers could be replaced by features available in the server. For instance, triggers to update columns with the latest update time and user information can be replaced with the corresponding special values in the server. As well, using the default settings on existing triggers can also improve performance.


Contents Index Use AUTOINCREMENT to create primary keys Minimize cascading referential actions