Type ahead on portal very slow
I have three portals on a layout with a search field box. (see screen shot below). So whenever a user types in part of either the company name or the full name, only the relevant rows appear in the portal. Although it works, it is incredibly slow. I'm looking for ways to make the process faster.
The layout is based on a table called shoots and leaves, and the portals are from a table called orders. The tables are related through the relationship:-
Shoots and Leaves id X Orders id
and I use filtering to only show the desired rows.
The company name and the full name are from the related table customers. I combine these two fields into a single field called super search field and then use patterncount to show the results:-
Patterncount(Orders::Super search field, Shoots and Leaves::Global search field)>0
can anybody suggest ways of making it faster ? Thanks