News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Deactivating records

Microsoft Dynamics CRM (Archived)

Deactivating records

(0) Share

Report

Report

Posted on by G.Vetere

Does anyone know if deactivating records helps search performance?

I'm looking at how to speed up search performance and wondered if deactivated records are excluded from searches (not Advance Find)

*This post is locked for comments

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Charles Abi Khirs 3,569 on at

Like (0)

Report

RE: Deactivating records

Hello,

I don't think that Deactivating records can help in search performance because Active and Inactive records resides under the same table, the where condition of the SQL query executed will return the set of records.

However, you can try few things in order to improve the performance:

1. Reorganize and Rebuild Indexes: docs.microsoft.com/.../reorganize-and-rebuild-indexes

2. Check/Manage POA table size: support.microsoft.com/.../how-to-control-principalobjectaccess-table-growth-in-microsoft-dynamic

3. Check/Manage Async table size: support.microsoft.com/.../performance-is-slow-if-the-asyncoperationbase-table-becomes-too-large
G.Vetere on at

Like (0)

Report

RE: Deactivating records

Yes I know that, my question is whether in the background they are still included in the searched or excluded entirely from the search before the results are shown
T.I.A 1,760 on at

Like (0)

Report

RE: Deactivating records

In the global search only active records should be returned by default.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,735 Super User 2024 Season 2

#2

Martin Dráb 230,466 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans