What do you do if you have a vocabulary source table [sys_user] with more than 100000 records

apriled
Tera Expert

‎03-21-2023 08:51 AM

I'm creating my own vocabulary source against [sys_user] to replace the OOB @personName vocabulary source. I have applied the appropriate filters to reduce the number of values and # of records is still over the 100K limit

Any suggestions on how to correct / get around this other than modifying the system property?

apriled_0-1679413637705.png

 

0 Helpfuls
  • 446 Views
2 REPLIES 2

Community Alums
Not applicable

‎03-21-2023 09:33 AM

Hi @apriled ,

You should create a single custom NLU Model and import the intents from the out-of-box models. You can then create a new Vocabulary Source @personNameABC and add your custom condition/filter on this Lookup Source. You will then need to review all the NLU intents that reference the @personName vocabulary source and change it to the new Vocabulary Source @personNameABC, so that the @personName Vocabulary Source is no longer associated with your new custom NLU Model.

 

0 Helpfuls

apriled
Tera Expert
In response to Community Alums

‎07-11-2023 12:11 PM

Thanks for the reply, however we have over 100K users and I need to figure out how to sync/use the source with this many records.

0 Helpfuls