Microsoft KB Archive/162701

= ACC97: Microsoft Jet 3.5 Performance White Paper Available in Download Center =

Article ID: 162701

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q162701



Advanced: Requires expert coding, interoperability, and multiuser skills.



SUMMARY
The V35perf.exe file contains an overview of Microsoft Jet Database Engine version 3.5. The overview discusses the primary goal of Microsoft Jet Database Engine 3.5, benchmark timings, details on performance enhancements, and configurable performance settings.

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

Download V35perf.exe now

The V35perf.exe file contains the following files:   V35perf.doc     The Jet 3.5 Performance White Paper Readme.txt     Information on converting from Word 97 format 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 "Microsoft Jet 3.5 Performance" white paper contains the following topics: Table Of ContentsOverview Architecture Changes Non-configurable Performance Settings
 * Reduced Locking
 * Improved Rushmore Algorithms
 * Removal of Implicit Transaction for SQL DML Statements
 * Reduced Index Btree 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 Values
 * New MaxBufferSize Formula

Configurable Performance Enhancements
 * Programmatic Run-Time Registry Control
 * Programmatic Control of Flushing Jet's Write Cache
 * Programmatic Control of Refreshing the Cache
 * Improved Control over Lock Retries
 * Improved Functionality with NetWare Network Operating System
 * Improved Page Recycling
 * New Asynchronous Writing Techniques

Optimization Tips and Techniques
 * Prevent Unnecessary Query Recompilation
 * Compact Frequently
 * Avoid Embedding Expressions in Queries
 * Cautiously Use Indexes
 * Use SQL DML Statements Instead of DAO Looping Constructs
 * Implement Persistent Connections with Linked (Attached) Tables
 * Use Explicit Transactions When Implementing Online-Transaction Processing (OLTP)
 * Check Parameterized Queries for Optimal Performance

Unsupported Tuning Features
 * The ISAMStats Function
 * The ShowPlan Function

Conclusion

Additional query words: jet 3 5 V35perf exe doc

Keywords: kbdownload kbfile kbgraphxlinkcritical kbinfo KB162701

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.