I'm setting up a new portal that filters companies based on criteria. I would like to get some advise on how to set this up with optimum performance (fastest speed and least strain on the system)
Is it best to use a filtered portal or to filter through relationship?
Also, If I need to filter the list by the States that a company services what is the best way to set this up using a relationship?
Should I match a field that contains all the states that the company services and relate it to a calculation field that has all of the states in a list?