

As a system admin, use the following best practices to optimize your Relativity environment.
Use the appropriate field type and length for text fields within Relativity.
Fixed-length text - a text field with a limited character length.
Long Text - a text field larger than 4,999 characters.
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:
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, Relativity Integration Points, or Relativity Processing to import data into Relativity.
There are two methods of importing native/TIFF files when using the Relativity Desktop Client or Relativity Integration Points:
Note: Use this option when native files already have been copied to their final location and are 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 either method, the selected native file path field should point to the current location of the native files.
Many customers 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 Relativity Desktop Client or Relativity Integration Points 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.
Note: This value is configured using the MaxAnalyticsIndexIdleDays value in the Instance Settings tab.
Follow these best practices for views and searching:
If possible, use a Contains condition instead. In order to use Contains, you must add the field to the Full Text Index.
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.
When you want users to agree to a disclaimer message when using Relativity, you can create a custom message and an agreement button for users when they first log in to the Relativity environment. This type of message is useful to ensure that users acknowledge Relativity terms of use or the confidential nature of Relativity content.
To customize a disclaimer on a Relativity login page, use the following steps:
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.
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.
On this page
Why was this not helpful?
Check one that applies.
Thank you for your feedback.
Want to tell us more?
Great!