Performance Enhancements in Microsoft Jet 3.5
Microsoft Jet 3.5 includes features that significantly improve performance. The following sections discuss the performance enhancements of Microsoft Jet 3.5, as outlined below:
New configurable performance settings and changes to existing settings:
-
Multithreading
-
Dynamic memory usage
-
Asynchronous writes
-
Cache refreshing
-
Controlling lock retries
-
Setting the maximum number of locks
-
Controlling long value page recycling
-
Using the SetOption method to control Microsoft Jet registry settings
-
Programmatically refreshing the Microsoft Jet cache
Key internal performance enhancements:
-
Reduced locking
-
Improved Rushmore algorithms
-
Removal of implicit transactions for SQL data manipulation language (DML) statements
-
Reduced index navigation
-
Improved cache reuse
-
Persistent connections to security system tables
-
Reduced flushing of the cache
-
Larger allocation by extents
-
Improved performance with DELETE statements
-
Faster generation of query plans
-
Explicit registry settings and values