Optimizing PS/nVision Performance

This section discusses:

• Tree Joins.

• Designing Indexes - Combination Guidelines.

• Capturing SQL.

PS/nVision is a complex tool, capable of producing a great variety of reports from a variety of database tables. The SQL statements it generates are not necessarily complex, but they are very sensitive to the performance of the underlying database, especially in the following areas:

• Large tables (ledgers often have millions of rows) make efficient use of indexes essential.

• The use of trees and reporting (security) views cause multiple tables to be joined.

  The efficiency with which the database processes these JOIN statements dictates most of the performance of PS/nVision.

Unlike traditional background reporting tools, PS/nVision supports interactive, focused reporting with a probing or querying approach to accessing the database. PS/nVision queries tend to be more numerous than traditional report writers are, but also more focused on the specific data that you want to see.