Hi,Ik noticed the standard DNN Search on my DNN community version 06.01.03 was very slow, compared to another DNN installation.After much digging I found the difference between the versions lying in the SP "GetSearchResultsByWord".There seems to have been a bugfix:/* Fix bug 14543: Update GetSearchResultsByWord to exclude deleted tab modules*/It modyfies the SP to include the clause "AND (tm.IsDeleted = 0)"When I remove this clause again, the SP runs a 100 times faster!!I understand that the clause needs to be added again, but does anyone know why it is such a performance killer?Thanks in advance!RikBelow I pasted a copy the SP [GetSearchResultsByWord] SELECT si.SearchItemID, sw.Word, siw.Occurrences, siw.Occurrences + 1000 AS Relevance, m.ModuleID, tm.TabID, si.Title, si.Description, si.Author, si.PubDate, si.SearchKey, si.Guid, si.ImageFileId, u.FirstName + ' ' + u.LastName As AuthorName, m.PortalId FROM dbo.SearchWord sw INNER JOIN dbo.SearchItemWord siw ON sw.SearchWordsID = siw.SearchWordsID INNER JOIN dbo.SearchItem si ON siw.SearchItemID = si.SearchItemID INNER JOIN dbo.Modules m ON si.ModuleId = m.ModuleID LEFT OUTER JOIN dbo.TabModules tm ON si.ModuleId = tm.ModuleID LEFT JOIN dbo.TabModuleSettings tms ON tms.TabModuleID = tm.TabModuleID AND tms.SettingName = 'DisableSearch' INNER JOIN dbo.Tabs t ON tm.TabID = t.TabID LEFT OUTER JOIN dbo.Users u ON si.Author = u.UserID WHERE (((m.StartDate Is Null) OR (GetDate() > m.StartDate)) AND ((m.EndDate Is Null) OR (GetDate() < m.EndDate))) AND (((t.StartDate Is Null) OR (GetDate() > t.StartDate)) AND ((t.EndDate Is Null) OR (GetDate() < t.EndDate))) AND (sw.Word = @Word) AND (t.IsDeleted = 0) AND (m.IsDeleted = 0) AND (tm.IsDeleted = 0) -- This is the performance killer!! AND (t.PortalID = @PortalID) AND (tms.TabModuleID is NULL) ORDER BY Relevance DESC