On-demand event loading

The original DayPilotScheduler allows showing a long time range (one year with one cell per day is not a problem). However, it renders all the events at once. In case that you have hundreds of events it will render very slowly and the callbacks and postbacks will take a lot of time.

DayPilotSchedulerDynamic offers a major improvement: It loads only the events that belong to the current view port (only a limited time range and a limited set of resources).

The advantages are obvious:

• You can show many more resources (adding more resources won't slow down the control)
• The control renders quickly with a full schedule as well.

When you scroll down or right, it sends a request for a new set of events to the server (Scroll event) and updates quickly. The background cells are rendered after the event set is loaded. The white background area indicates that the events were not loaded yet.

When binding the data source (during the initial loading, during scrolling or after an update) you can get the information about the visible area using ViewPort property:

DateTime firstVisibleDate = DynamicScheduler1.ViewPort.Start;
DateTime lastVisibleDate = DynamicScheduler1.ViewPort.End;
List<string> visibleResourcesIDs = DynamicScheduler1.ViewPort.Resources;

You should use the ViewPort property to limit the SQL query.