Larger Allocation by Extents

Microsoft Jet 3.0 allocates up to 8 pages (16K) at a time when adding data to a table. This allows data to be contiguous within a table, thus optimizing sequential reads and the Microsoft Jet read-ahead cache. Microsoft Jet 3.5 allocates up to 32 pages (64K) at a time when adding data. Increasing this maximum allocation results in improved performance. Like Microsoft Jet 3.0, Microsoft Jet 3.5 only adds large extents to tables when large numbers of records exist in a table.