As a system admin, use the following best practices to optimize your Relativity environment.
This page covers the following topics:
- Fixed-length vs. long text field types
- Fixed-length text field considerations
- Unicode support
- Data imports
- Views and searching
- Tally/Sum/Average mass operation
- Group by for Pivot
- User notifications
Use the appropriate field type and length for text fields within Relativity.
Fixed-length text - a text field with a limited character length.
- Maximum technical limitation of 4,999 characters
- Examples: Author, Email From, Email Subject
Long Text - a text field larger than 4,999 characters.
- The technical limitation on a long text field is 2 GB.
- Relativity is typically configured to stream files smaller than 50 MB. You can set the maximum file size in the Instance Setting table.
- Only the first 20,000 characters appear in Layouts and Views.
You can create indexes on particular columns to improve performance for queries against large databases.
Consider these SQL limitations when deciding between the two field types: you can't create an index on a column with a type of Long Text, a Unicode-enabled fixed-length text field of more than 450 characters, or a non-Unicode-enabled fixed-length text field of more than 900 characters.
If there are more than 8,060 characters in a single database row, SQL may experience performance issues. As a result, a best practice is to limit the length of fixed-length text fields.
You can get the total field length usage for any workspace by viewing the document object properties in the Object Type tab for that workspace. This also applies to any dynamic objects.
When you create a fixed-length text field, configure the length of the field to the appropriate size. You can increase the length as necessary throughout the life of the workspace. If you have a field that will never exceed a certain length, set the length of the field to that value.
For example, a Document Extension field should have a small field length value. If there is a field that could eventually grow to a great length—a Unicode-enabled fixed-length text field of more than 450 characters or a non-Unicode-enabled fixed-length text field of more than 900 characters—then set it as a Long Text field initially rather than a Fixed Length Text field.
Note: For more information on limiting the total length of text fields in SQL, see http://msdn.microsoft.com/en-us/library/ms186981.aspx.
After any major cleanup or length reduction of fixed-length text fields in a workspace, run the DBCC CleanTable SQL Script after hours on the database to reclaim free space. For the steps on running this script, see http://msdn.microsoft.com/en-us/library/ms174418.aspx.
Define the Unicode Enabled property of a field prior to importing data. A database level operation to convert a field’s data from Unicode to non-Unicode (or vice versa) can take a long time, lock tables, and potentially timeout if performed on a large data set in Relativity.
Only the following field types are Unicode-compatible:
- Fixed-Length Text
- Long Text
- Single Choice
- Multiple Choice
Define the Extracted Text field as Unicode if there is a possibility that text in languages other than English will be loaded into the workspace.
Use the Relativity Desktop Client or Processing to import data into Relativity.
There are two methods of importing native/TIFF files when using the Relativity Desktop Client:
- Copying files from the original location in the selected load file field to the document repository. This copies the files from the original location in the selected load file field to the selected document repository.
- Importing files that already reside in a valid, Relativity-accessible location.
Note: Use this option when native files already have been copied to their final location, accessible by Relativity. This location should be separate from that of the Relativity document repository. You can set the default option on an environment-wide level.
For more information, see Instance setting descriptions.
For either method, the selected native file path field should point to the current location of the native files.
Many clients use the second option to reduce the total time it takes to load files into the Relativity repositories. You can manually copy files to where they should reside and then provide the Relativity Desktop Client with pointers to their locations. This can save significant time when loading large amounts of natives and/or TIFFs.
Note: Never run the Relativity Desktop Client on a Relativity production server (Web, Agents, SQL, or Search). Launch the tool on a different server or workstation to prevent resource contention.
Use the following guidelines when setting up an Analytics index in your workspace.
- When populating an Analytics index, exclude non-conceptual files such as XLS, EXE, or RAR from the index. Make sure that the Training Set is limited to documents with less than 2 MB of Extracted Text.
- Disable queries on indexes that are no longer being actively used. Queries are automatically disabled for indexes that haven't been accessed within a pre-set number of days.
Note: This value is configured using the MaxAnalyticsIndexIdleDays value in the EDDS.EDDSDBO.InstanceSetting table.
- When queries are enabled on an Analytics index, the index is loaded into RAM. Unused indexes shouldn't consume resources on the CAAT server.
- Use the following guidelines when setting up a structured analytics set in your workspace.
Follow these best practices for views and searching:
- Avoid Is Like and Is Not Like statements on un-indexed queries. Full table scans on large databases using Is Like statements severely load the server. A full table scan occurs when a query reads every row in a table in order to locate the required information.
If possible, use a Contains condition instead. In order to use Contains, you must add the field to the Full Text Index.
Note: Is Set and Is Not Set criteria also triggers a full table scan. A full table scan operation can be very IO-intensive and take a while to complete on slower storage units.
- Prevent users from filtering and/or sorting on Long Text fields within the document list in large workspaces. To do this, make sure the field's Allow Sort/Tally property is set to No.
In the Tally/Sum/Average mass operation, the Tally option is audited. For the set of requested documents, it lists each unique value found in that field along with the frequency of each occurrence. The process can run on Fixed Length Text, Choice, User, and Number fields.
Tallying on un-indexed columns in large workspaces can take a while to complete and slow down database/system performance. Be sure to place indexes on columns in SQL that are regularly tallied in large workspaces.
You can disable the ability to Tally in a workspace by setting each field's Allow Sort/Tally property to No.
When performing Pivot operations in large workspaces, you can improve Pivot performance by placing a non-clustered index on the field being grouped on. Use SQL Server Management Studio to place the index.
There are several notifications available to help system admins better manage their Relativity environments.
To customize a disclaimer on a Relativity login page, use the following steps:
- Navigate to the web server(s) at C:\Program Files\Relativity Corporation\Relativity\EDDS.
- Locate the text file, Disclaimer.txt, and update it with your disclaimer text. You must use plain text only; HTML will not display here.
- Update the DisplayDisclaimer instance setting value to true to display the disclaimer message.
Message of the Day (MotD)
The Message of the Day (MotD) is a message displayed to all users when they log in to Relativity. MotD is most commonly used to inform users of planned system maintenance.
To activate or change the message of the day, navigate to the Instance Details tab from Home.
The user status page displays a list of users currently logged into the system. To access the user status page, navigate to the User Status tab from Home.
You can also send messages to any logged in users. This is helpful if you require emergency downtime during a review. System admins can also force log out users from the system on this page.
Default workspace tabs
When a user enters a workspace within Relativity, they are usually taken to the Documents tab. You can change this default setting in the Tabs tab of any workspace.
Set the Is Default property to Yes for the tab that you want to designate the default tab in a workspace. If a user doesn't have access to the Default tab, he or she will be directed to the Documents tab.
Modifying the default tab may be helpful in informing users of any upcoming workspace-level maintenance. Additionally, system admins can direct users to custom pages that contain links to instructional items, important information about the matter, or an overview of workspace review progress.