Dynamic Content filtering in backend have to many ORs and query returns Timeout
Hi all,
When in the backend of sitefinity we search in NewsItem it looks on the Title if Contains the word.
www.fxstreet.com/.../
Title%5B%22%22%5D.ToUpper().Contains(%22trade%22.ToUpper()))
But when we search in DynamicContent let says Analysis(in our system is quite similar to NewsItem table structure) it looks in all the string fields if they Contains the word so the query its to slow and results in a timeout.
www.fxstreet.com/.../
(FXContent.ToUpper().Contains(%22trade%22.ToUpper()) %20OR%20
Title.ToUpper().Contains(%22trade%22.ToUpper()) %20OR%20
Content.ToUpper().Contains(%22trade%22.ToUpper()) %20OR%20
Summary.ToUpper().Contains(%22trade%22.ToUpper()) %20OR%20
PostId.ToUpper().Contains(%22trade%22.ToUpper()) %20OR%20
PostAuthorId.ToUpper().Contains(%22trade%22.ToUpper()) %20OR%20
PostCompanyId.ToUpper().Contains(%22trade%22.ToUpper()) %20OR%20
PostLanguageId.ToUpper().Contains(%22trade%22.ToUpper()) %20OR%20
PostImageUrl.ToUpper().Contains(%22trade%22.ToUpper()) %20OR%20
PostImageCaption.ToUpper().Contains(%22trade%22.ToUpper()) %20OR%20
PostImageCopyright.ToUpper().Contains(%22trade%22.ToUpper()) %20OR%20
FullUrl.ToUpper().Contains(%22trade%22.ToUpper()) %20OR%20
PostFeedId.ToUpper().Contains(%22trade%22.ToUpper()) %20OR%20
MetaTitle.ToUpper().Contains(%22trade%22.ToUpper()) %20OR%20
MetaDescription.ToUpper().Contains(%22trade%22.ToUpper()) %20OR%20
MetaKeywords.ToUpper().Contains(%22trade%22.ToUpper()) %20OR%20
VideoUrl.ToUpper().Contains(%22trade%22.ToUpper()) %20OR%20
SponsorTitle.ToUpper().Contains(%22trade%22.ToUpper()) %20OR%20
SponsorUrl.ToUpper().Contains(%22trade%22.ToUpper()) %20OR%20
SponsorImageUrl.ToUpper().Contains(%22trade%22.ToUpper()))
So my question the DynamicContent filter can be customizables and how to do it?
Regards