Hello, upon checking, it seems I underestimated the number of items. It was actually around 9400 records.
I also took another look at it, and the worst case scenario is actually 170,000 items (although we definitely do not want this to happen.)
I am thinking it’d be best if the user can only select 100 items at a time (I still need to discuss with the team for the actual number but 100 seems good enough to start with). If the user chose more than 100, an error should say that they should not be able to select more than 100 items.
Additionally, in the scenario where the choices is too abundant, if the user hits Select All, the app shouldn’t crash/be unresponsive. The best case would be to remove the Select All button if there’s more than 100 items available; only show it if they narrow down the list.
Additional details: I will actually pair this up with Adding rows to another table, one for each item in this enumlist. So I have to limit the number of items because it might cause more performance issues.