Dynamic Content filtering in backend have to many ORs and qu

Posted by Community Admin on 04-Aug-2018 10:55

Dynamic Content filtering in backend have to many ORs and query returns Timeout

All Replies

Posted by Community Admin on 10-Oct-2016 00:00

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

This thread is closed