Lookup to large Dataset (CRUD pages) times out

Hi,
I have a 'Customer' table with > 2 mil records.

I have a 'Contact' table, with a foreign key to the ID field of this 'Customer table'.

When Radzen creates the CRUD forms for the 'Contact' table, the Edit and Add Contact forms give a (serverside) timeout as they try to load the complete Customer table (to populate the dropdown?)

How can this be solved?

I would prefer that for Add/Edit, a sort of search (filter with paging) is used.

How can I remediate this?

Hi @HansH,

You can try checking the following option in the CRUD screen:

This will tell Radzen to generate DropDownDataGrid which uses paging by default.

Hi,

This option is greyed-out in the Community Edition.

Regards,

Hans