<< Click to Display Table of Contents >> Navigation:  Apollo VCL Components > Optimizing Performance > Optimizing Performance

 

The following sections contain tips that can help Apollo developers squeeze the utmost in performance out of the database engine through various techniques and tricks. Some of these tips are not unique to Apollo, and also apply to Xbase and DBMS systems in general. Note that most optimizations involve making direct API calls to the Apollo database engine.

The main topics for increasing performance are as follows:

 

Appending Records

Direct Calls To Apollo API Functions

Disabling Data-Aware Controls

Filtering, SetScope and Query

Handling Deleted Records

Optimistic Buffering

Optimizing Performance under Client/Server

Query Optimization Tips

Shared Mode versus Exclusive Mode

Speed Mode

Updating Records