How do I keep a VS Lightswitch Combo box from timing out?

Question

In a Lightswitch Desktop Client (C#) application I have a List/Detail screen where I add participants to a class roster. This application has been in use for more than a year and has worked fine but now the "Participants" table has grown to more than 2500 records. The List/Detail screen for "Classes" has a sub form for "RosterAttendences". In the RosterAttendences sub form there is a combo box/pulldown to list all of the participants in the Participants table so that the data entry person can add records for individuals to the roster for that class. In the test instance on VS it works fine but with live application/data it times out. First the spinning blue circle will appear as soon the down arrow is selected and eventually (more than a minute) it will stop and be replaced with a red X. All of the other combo boxes in the application function properly and the current work around is to add the classes in the participant's profile which also is working properly. Is there a way to optimize the combo box so that it does not time out?

Answer 1

Change the field from Auto Complete to Modal Window Picker when more than say 100 records. You get searching, sorting and paging but there are usability concerns as it will take more mouse clicks but it's the only way to handle large amounts of data.

https://social.technet.microsoft.com/Forums/en-US/88001cd8-539c-47cd-8599-f1703d2a1cd9/how-do-i-optimize-a-combo-box-in-a-desktop-client-app-created-with-lightswitch-c?forum=lightswitch

Answer 2

If time is not an issue you might increase ClientTimeout