Configuration and Performance (Magic xpa 2.x)

To work with Magic xpa and SQL efficiently you need to understand the various concepts and techniques for achieving optimal Magic xpa and SQL performance. These are explained in the following topics:

Transactions

Locking

Null Value

Index Definition and Usage

Range Definition

Sorting

Stored Procedures

Reducing Network Traffic

Incremental Locate

Direct SQL