438 Performance Tuning for Content Manager
attributes included on a search dialog should be indexed for optimum database
efficiency.
Document Manager systems working with Content Manager contain additional
configuration settings within the search template definition that determines how
the search is performed in the database. On the Library tab of the Search
Configuration dialog, you can specify whether a search is performed across all
item types in the library or within a specific item type. This setting affects how
quickly the search results are returned to the user because searching across
multiple item types requires a database search that is run across multiple tables.
The same search run within a single item type returns information much faster
because the search is run in a single database table.
Another configuration setting within search template configuration enables you to
identify whether the search is case insensitive. Using this setting to perform
case-insensitive searches increases the amount of time it takes to return results
to the user because this type of search requires the database search to run a full
table scan instead of utilizing database indexes.
Item type configuration
Content Manager item type settings can affect performance of the desktop and
the overall system. Options such as attribute indexes and text searching can
optimize the system’s searching performance.
The item-type definition includes the ability to enable full text indexing for the item
type. Although enabling text searching does not have a significant impact on
desktop performance, it can inhibit users wanting to perform cross-item type
searches. If you allow users to perform content searches across all item types, all
item types must be set to text searchable.
Content Manager item types also enable the creation of attribute indexes.
Indexing can help optimize database searching, which results in better desktop
responsiveness and overall system optimization. We recommend creating single
attribute indexes for all attributes included in an item type that are being used as
search criteria. These include all attributes included on all user dialogs, attributes
used to identify uniqueness, and any attributes that are used for locating
documents by the Document Manager services such as document class,
document state, and revision number.
Get Performance Tuning for Content Manager now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
