Solving a big Delay when use a lookup for more 70,000 rows !

[waleed51]

I have a (Visits) grid which records visits transactions to my company ,
and it have a relation with (Visitor) -Visit have one or more visitors- ,

I use a Visitors Row as Lookup in Visit dialog, to can select visitor when I add a new Visitor transaction, ( like in Picture).

the problem is Visitor table have more 70,000 rows, when I use it in lookup it make a big delay for searching on it to retrieve data.

Is there is any way to not load all lookup, only load based on search in lookup, or any alternative option compatible with my business?

[VictorTomaili]

Did you try the AsyncLookupEditor?

[waleed51]

no, i don't know it,

plz, can you give me more explanation ??

[waleed51]

@VictorTomaili ??

[waleed51]

I search for AsyncLookupEditor, as I understand it's not meet my business , i want all elements in lookup, i may want to search about anyone at any time,

i think my nees is to upload lookup elements only on search in select2 => upload from database based on which one i search for

[VictorTomaili]

Duplicated #5417