Hi Scott,
The reason for getting the behavior is that the grid tries to find its key by iterating in the collection of items. This happens each time when user inputs a character. Iterating through 30000+ items for every character causes this delay. To solve this issue, the user has to override this written logic. For this, the custom cell type for foreign key relation has to be made. This can be achieved by deriving the GridTableDropDownListCellModel and GridTableDropDownListCellRenderer classes. In the derived renderer, the FindItem method is override and logic has to be rewritten to required behavior.
Please refer this sample;
http://websamples.syncfusion.com/samples/Grid.Windows/I34619/main.htmIt has a custom foreign key look up celltype that assumes the foreign key list is ordered (ascending) by the display value so it can do a binary search in a renderer.FindItem override. (Note that once an item is found using a binary search, the FindItem uses a linear search to move back up in the list to locate the first item that matches.)
Best regards,
Haneef
Note :
Doc :
GridfindLogic.zip