HP 3000 Manuals HP 3000 Manuals
Limits on Table Size
For performance reasons, Access Server limits the size of tables in the
following ways:
* Result tables. When users work with "remote tables," their result
tables cannot contain more than the number of records configured
as the maximum table size. The default for this value is 100,000
records.
* Saved tables. Because users cannot create result tables having
more than the specified maximum number of records, it follows that
saved tables are likewise limited to the specified number of
records.
* IMAGE and File tables. Access Server will not load an IMAGE or
file table with more than the maximum number of records. A table
of this size can only be accessed in three ways:
* By using Define Query to arrive at a result table that
conforms to the specified maximum number of records. This
is allowed because Access Server does not load the IMAGE or
file table, but the smaller subset defined by the user's
query. (By loading, we mean the gathering of the data into
a temporary MPE file for viewing and manipulation by the
user.)
* By performing a Summarize operation on the table.
* By choosing Sample Values on the Define Query screen. The
first twelve records in the table are displayed.
The limit on the size of tables that your users can access does not
affect the size of the tables you can configure in the Administrator
Utility:
* You can configure an IMAGE or file table containing more than the
specified maximum number of records. You can then (1) configure
smaller view tables from that table, and/or (2) let your users
either summarize it or define queries against it that reduce the
number of records to the maximum number or less.
* You can also configure a view table that if accessed would contain
more than the maximum number of records you specified. Your users
will not be able to load the entire table, but as long as any view
tables derived from the original view table satisfy the maximum
number of records limit, your users will be able to access them.
You can change the maximum table size with the Change Maximum Table Size
(CTS) screen. (See "Changing Maximum Table Size" under "Environment
Configuration" in Chapter 2.)