Visible range and recurring appointments with database provider

2 posts, 0 answers
  1. Sean
    Sean avatar
    3 posts
    Member since:
    Apr 2011

    Posted 29 Dec 2014 Link to this post

    I am attempting to increase the performance of the Radsheduler by pulling only those appointments within the visible range. The control is extremely slow if I do not. I have recurring appointments that span 3 months and if I navigate past the original appointment and retrieve the appointments from my database based on the visible range I lose the recurring appointments. If I expand the range to overlap the original appointment I get all the recurring appointments. Is there a way to query via linq using the visible start and end range and still get the recurring appointments without having to increase the range which defeats the purpose of using only the visible range? The documentation below contradicts itself from one sentence to the next. If I utilize a great deal of recurring appointments them I stuck with poor performance?  Getting all data from the database is really not an option because the control performs terribly.

    From Documentation:

    You can use the RadScheduler properties to optimize your query. For example, the VisibleRangeStart and VisibleRangeEnd properties can be used to limit the number of records that the query retrieves. Recurring appointments are evaluated in-memory, however, so they should be always retrieved regardless of VisibleRangeStart and VisibleRangeEnd.
  2. Plamen
    Plamen avatar
    3080 posts

    Posted 01 Jan 2015 Link to this post


    The only possible working solution is to select the appointments from the visible range and those whose recurrenceRule is not empty string as for example it is defined in the Performance demo.

    Hope this information will be helpful.


    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

Back to Top