<< Click to Display Table of Contents >> Navigation:  Apollo VCL Components > Optimizing Performance > Shared Mode versus Exclusive Mode

In Shared mode (TApolloTable.Exclusive set to False), skipping through an active index order requires the index file to be locked for the duration of the repositioning. Under Exclusive mode (TApolloTable.Exclusive set to True), no locking is required, thus resulting in much faster skips.

 

Most other table-related operations, including Appends and Replaces, are also faster in Exclusive mode than in Shared mode.

 

For networked applications, it is generally required that the tables are opened with Exclusive set to False (the default). However, for local tables and/or temporary tables on the network, set Exclusive to True whenever possible for the best performance.