ACC95: Microsoft Jet 3.0 Performance Overview Available in Download Center (148582)

SUMMARY

The V3perf.exe file contains an overview of Microsoft Jet Database Engine version 3.0. The overview discusses the primary goal of Microsoft Jet Database Engine 3.0, benchmark timings, and details on performance enhancements.

The following file is available for download from the Microsoft Download Center:

Download V3perf.exe now

The V3perf.exe file contains the following file:

   V3perf.doc

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

MORE INFORMATION

The "Jet 3.0 Performance Overview" white paper contains the following topics:

OVERVIEW
ARCHITECTURE CHANGES
- CONFIGURABLE PERFORMANCE SETTINGS
- - Threading
  - Dynamic Memory Usage
  - Improved Buffer Refreshing
  - Asynchronous Writes
- KEY NONCONFIGURABLE PERFORMANCE ENHANCEMENTS
- - 32-Bit
  - Common Buffering Code
  - LRU Buffer Replacement Policy
  - Simplified Index Structure
  - Key Compression in Indexes
  - Space Management
  - Compaction
  - Reduced Read Locks
  - Improved Conflict Detection
  - Modifications to Long Value Storage
SAMPLE BENCHMARK TIMINGS
- LOAD TIMES -- ASCII FILES
- INDEX TIMES
- DELETE TIMES
- INSERT TIMES
- READ TIMES
- RUSHMORE TIMES
- UPDATE TIMES
- MULTIUSER