Configuration Properties for Tables

Use these configuration properties to tune table performance.
Property Name
Description
webdms.workspaceServer.allowGetRecordCount
specifies whether to retrieve all of the rows for database tables. The default value is true. If you set this property to false, performance improves, but you might not see all rows of the table. For example, for large tables, total rows and filtered rows appear as Unavailable in the user interface. If the table has less than 100 rows or you scroll to the last page of the table, the values for the total rows and filtered rows are shown.
This property does not apply to SAS data sets.
webdms.workspaceServer.cacheTableRows
specifies whether to cache the rows from database tables to improve performance. The default value is true.
If you use caching, the row count could be wrong if you modify the table. You must click Refresh to remove the value from the cache and to force a re-query of the database. If correct row count is more important than performance improvement, set this property to false to disable caching.
webdms.workspaceServer.largeTableRows
specifies the maximum number of rows to display in the table viewer. If the number of rows in the table is unknown or greater than the value specified for the webdms.workspaceServer.largeTableRows property, the following behavior occurs:
  • SAS Studio displays a warning that sorting could take a long time.
  • SAS Studio does not generate a list of distinct values to select from when SAS Studio filters the data.
The default value is 50,000.
Last updated: May 9, 2017