Removing old appointment data

3 posts, 0 answers
  1. Clyde
    Clyde avatar
    41 posts
    Member since:
    Feb 2008

    Posted 23 May 2011 Link to this post

    Performance of our RadScheduler has been getting progressively worst as the number of records grow. We are using the suggestions mentioned around filtering the appointments for just the view being displayed.

    The problem is that over the past 2 years a substantial number of recurring entries have been added, most of which have expired and are no longer valid. As we have little requirement for reviewing past appointments it would be beneficial to remove these entries.

    Has anyone figured out a good way to archive off this data or remove it entirely? Some routine that calculates out each recurrence rule to see if it's still valid?

    Any suggestions would be appreciated.

    Thanks
    Clyde
  2. Alex
    Alex avatar
    17 posts
    Member since:
    Sep 2005

    Posted 24 May 2011 Link to this post

    Hi Clyde,
    One quick option would be to create an admin page that would allow you to delete all old appointments that are no longer valid. There is some example code here:

    http://www.telerik.com/support/kb/aspnet-ajax/scheduler/how-to-display-all-radscheduler-appointments-in-gridview.aspx

    It will allow you to display all Appointment (including recurring). You could place your logic in there to get a list of ID's that need to be removed from your appts table. Perhaps not the most elegant solution but if it only needs to be done every year or so it should get the job done.
    HTH
    Alex

  3. Clyde
    Clyde avatar
    41 posts
    Member since:
    Feb 2008

    Posted 27 May 2011 Link to this post

    Still open for suggestions, but will try using the code from the gridview example to calculate 2 years out on whether an appointment reoccurs. If not then archive/delete. I'll post my code when done as I'm sure I'm not the only one with this problem.
Back to Top