Understanding What Jet 4.0 Does to Improve Performance
Improvements made to the Jet 4.0 Engine, which is included with all versions of Access subsequent to Access 2000, have dramatically improved its performance over that of its predecessors. Some of these improvements appeared with the Jet 3.0 Engine that shipped with Access 95 or the Jet 3.5 Engine that shipped with Access 97, but many are new to Jet 4.0. The Jet 4.0 Engine is thoroughly 32-bit. It takes advantage of multiple execution threads, providing significant performance benefits.The following are improvements introduced in Jet 4.0:
- Data page size is now 4KB instead of 2KB. This increases the maximum database size from 1.07GB to 2.14GB, and provides better performance for many operations because of a decrease in I/O.
- The native OLEDB Provider offers superior performance to ODBC data.
- The first 255 characters of memo fields can be indexed. This significantly improves performance when searching and sorting memo fields.