RadScheduleView in Lightswitch with large appointment list

[John]

I followed the example project for integrating RadScheduleView into a Lightswitch application. My appointments table has 38000 records in it so I set the table page size to 50,000. If I then use the entire table as the datasource, the scheduler hangs. But if I try and filter appointments on date within visible date range of the scheduler then I will miss recurrent appointments. Is there a limit to the number of rows in the datasource? Any tricks to binding to it in this situation?

[John]

Actually it seems it is the loading of the screen datasource that takes all the time - its not the fault of the scheduler. If I enable paging and set page size to below 5000 then it loads in an acceptable time. If I increase the page size or disable paging altogether then the table loading seems to hang. But I still need to get all the data to the scheduler somehow. Is there another means?

[Ivo]

Hello John,

Actually, you load on demand functionality can be implemented for recurrence appointments too. You will have to create query and  modify the query into the PreprocessQuery event handler.

You can find attached a sample example.

Kind regards,
Ivo
the Telerik team

[John]

Awesome, thank you Ivo.