Adaptive Server extended-limit capabilities vary by type of
table and the database logical page size.
Allpages-Locked (APL)Tables
|
Maximum APL table limits
|
Number of columns
|
Column size 2K page
|
Column size 4K page
|
Column size 8K page
|
Column size 16K page
|
|---|
|
Fixed-length column
|
1024
|
1960 bytes
|
4008 bytes
|
8104 bytes
|
16296 bytes
|
|
Variable-length column
|
254
|
1948 bytes
|
3988 bytes
|
8068 bytes
|
16228 bytes
|
Data Row and Data Page Tables for Data-Only-Locked (DOL) Tables
|
Maximum DOL table limits
|
Number of columns
|
Column size 2K page
|
Column size 4K page
|
Column size 8K page
|
Column size 16K page
|
|---|
|
Fixed-length column
|
1024
|
1958 bytes
|
4006 bytes
|
8102 bytes
|
16294 bytes
|
|
Variable-length column
|
1024
|
1954 bytes
|
4002 bytes
|
8098 bytes
|
16290 bytes
|
Database Requirements for Varying Page Sizes
Database space requirements depend on the logical page size of the server. If your
model database is larger than the minimum size listed below,
then the minimum size of the database is equal to the model
database.
|
Databases
|
2K page
|
4K page
|
8K page
|
16K page
|
|---|
|
Default database size
|
3MB
|
6MB
|
12MB
|
24MB
|
|
master database
|
13MB
|
26MB
|
52MB
|
104MB
|
|
model database
|
3MB
|
6MB
|
12MB
|
24MB
|
|
tempdb database
|
4MB
|
6MB
|
12MB
|
24MB
|
|
sybpcidb database
|
24MB
|
48MB
|
96MB
|
192MB
|
Data Limits for Tables According to Page Size
Larger logical page sizes can contain more data.
|
Tables
|
2K page
|
4K page
|
8K page
|
16K page
|
|---|
|
Bytes per index key
|
600
|
1250
|
2600
|
5300
|
|
User-visible row length DOL table
|
1958
|
4006
|
8102
|
16294
|
|
User-visible row length APL table
|
1960
|
4008
|
8104
|
16296
|