Evaluating application performance

To identify areas of poor performance in your application, solidDB provides the following diagnostic tools for observing database performance:

▪ SQL Info facility, see SQL Info facility.

▪ EXPLAIN PLAN FOR statement, see Execution plans.

These tools are helpful in tuning your application and identifying any inefficient SQL statements in it.

In addition, the following commands provide useful information for evaluating performance:

▪ ADMIN COMMAND 'status', see STATUS.

▪ ADMIN COMMAND 'perfmon', see PERFMON.

▪ ADMIN COMMAND 'trace', see TRACE.

Go up to