AnsweredAssumed Answered

Fastest way to search for a portal (100,000 records)

Question asked by f.i.sciences on Dec 8, 2018
Latest reply on Dec 11, 2018 by BuzzardJunction

Hi community,


Here what I currently do:


     Script toggle on exit for a search field.

     Show user a message and PSOS for a find script who return list of keys (no sorted)

          (The list is created by a statistic field list)

     Set a field who has a relationship with a table on a portal who sort alphabetically.

     Clear user message.


Question, is this the best way to sort? Portal sort, relationship sort or script sort in the search on PSOS? Sorting the list before putting it to the relationship field doesn't do anything.


Is the statistic field list the best way to grab the keys list in the PSOS script?


Thank you.