Load Data Efficiently in RadzenDropDownDataGrid

I'm trying to imitate the lookup fields from Salesforce for an application. Where you have a dropdown you type into and the dropdown dynamically loads the records the user is searching for.

Right now the table it's looking up to is getting all the records from the table which is 150k. I need to limit how much comes into the lookup field or handle the data loading more efficiently.

If you can point me in the right direction on this, I would appreciate it.

I'm working on implementing this LoadData event, as well as thinking about turning it into a string operator.

The other thing I'm looking into is implementing the Filter API...Blazor DataGrid Filter API
Thanks for your help!