AnsweredAssumed Answered

Type ahead on portal very slow

Question asked by Kaps_1 on Nov 12, 2014
Latest reply on Nov 12, 2014 by philmodjunk


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