CHAPTER 1 Introduction
Configuration Guide 15
Adaptive Server extended-limit capabilities vary by type of table and the database logical page size. Table 1-2 lists the column and row limits for allpages-locked (APL) tables.Table 1-2: Allpages-locked (APL) tables
Table 1-3 lists the column and row limits for data-only-locked (DOL) tables.Table 1-3: Data row and data page tables.
Database space requirements depend upon the logical page size of the server.If your model database is larger than the minim size listed below, then the minimum size of the database is equal to the model database. Table 1-4 lists the minimum size for each database.Table 1-4: Database requirements for varying page sizes
Practical number of databases
participating in one query 16 Includes each occurrence of each
database queried and tempdb, if it
is used for results or worktables
Maximum number of tables with
referential integrity constraints
for a query
192
Procedure specifications
Number of buffers and
procedure buffers Configurable Limited by amount of RAM and
maximum size of shared memory
segment
Minimum memory required per
stored procedure 2K
Maximum number of parameters
per stored procedure 2048
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
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 8089 bytes 16290 bytes
Databases 2K page 4K page 8K page 16K page
master database 13MB 26MB 52MB 104MB