Database Object Page Limits Help

Database Object Page Limits

This feature is used to assign a limit to each of the Database Object Listing pages. This allows the list to be broken into manageable sizes which the user then pages through.

Field Description

Database Object Name On the "Add" screen, a Drop-down list which displays for selection, all available Database Objects.

Number of Entries per Page The maximum displayed entries per page. If there are more than this number of entries, the balance will show on continuing pages.

Number of Entries to Cache This field allows the Administrator to fine tune the cache requirements per individual Database Object.

TTL Maximum number of minutes to keep a Cached DBObject in memory in minutes. -1 == Do not expire this dbobject.

Field	Description
Database Object Name	On the "Add" screen, a Drop-down list which displays for selection, all available Database Objects.
Number of Entries per Page	The maximum displayed entries per page. If there are more than this number of entries, the balance will show on continuing pages.
Number of Entries to Cache	This field allows the Administrator to fine tune the cache requirements per individual Database Object.
TTL	Maximum number of minutes to keep a Cached DBObject in memory in minutes. -1 == Do not expire this dbobject.

When a value is specified here for a particular database object, queries on this object will only return the specified number of rows before the user is offered a "page" icon, which allows the remainder of the rows to be seen one group at a time. For example, if the "User" database object was limited to 10, and there were 50 users, 5 pages of users would be presented.

This setting only has an affect on the General Database Maintenance (DBMaint) servlet, and does not affect how many rows can be selected using this database object in any other program.