Valued Contributor.. Valued Contributor..
Valued Contributor..
73 views

SQL Search timeout when applying a search filter

Hi All

We are currently experiencing an issue where the search will time out if we apply a Record type filter or in the case of Audits an Event type filter

If we leave all types/events tagged there is no issue

DB stats are updated each night and we have just ran an update stats just in case but the issue continues.

Search timeout is set to 3 minutes

Currently running 9.3.1.300

Cheers

0 Likes
1 Reply
Highlighted
Outstanding Contributor.
Outstanding Contributor.

Re: SQL Search timeout when applying a search filter

How many History type objects do you have?

I have seen some CM datasets with 100s of millions of rows of History objects, and usually organisations don't provision their CM SQL server to be able to handle searching over a table that large...

You may see some improvement for that specific filter by adding an index to the oaEvent column on TSONLINEAU

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.