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