Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Monitoring and improving database performance » Improving database performance

 

Performance improvement tips


Always use a transaction log
Check for concurrency issues
Choose the optimizer goal
Collect statistics on small tables
Declare constraints
Minimize cascading referential actions
Monitor query performance
Normalize your table structure
Review the order of columns in tables
Place different files on different devices
Rebuild your database
Reduce fragmentation
Reduce file fragmentation
Reduce table fragmentation
Reduce index fragmentation and skew
Reduce primary key width
Reduce table widths
Reduce requests between client and server
Reduce expensive user-defined functions
Replace expensive triggers
Strategic sorting of query results
Specify the correct cursor type
Supply explicit selectivity estimates sparingly
Turn off autocommit mode
Use an appropriate page size
Use appropriate data types
Use AUTOINCREMENT to create primary keys
Use bulk operations methods
Use delayed commits
Use in-memory mode
Use indexes effectively
Use keys to improve query performance
Use the cache to improve performance
Limit cache memory use
Dynamic cache sizing
Dynamic cache sizing on Windows
Dynamic cache sizing on Unix
Monitoring cache size
Using cache warming
Use compression carefully
Use the WITH EXPRESS CHECK option when validating tables
Use work tables in query processing (use All-rows optimization goal)