Invision Community 5: A video walkthrough creating a custom theme and homepage By Matt Thursday at 04:02 PM
WebCMS Posted December 3, 2023 Posted December 3, 2023 If there are say more than 100 subforums and the user selects all of them except a couple of them (in the Fluid View Filter Checkboxes widget) which s/he is not interested in viewing their topics, it would be more performant to count the number of forums and number of checked boxes: If the number of checked boxes is greater than the number of unchecked boxes then WHERE forumId NOT IN (x,y,x) // Just address the unchecked forumIds to minimize the number of IN clauses // as opposed to - WHERE forumId IN (97 subforums IDs) else WHERE forumId IN (a,b,c,d,e,f...) end if HTH
Management Charles Posted December 3, 2023 Management Posted December 3, 2023 That could be true from an SQL perspective but... it's probably more performant to ask yourself why any community needs 100 subforums. Think about usability from a human perspective. Jim M and Marc 2
Recommended Posts