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
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 Answers, 1 is accepted
0
Alex
Top achievements
Rank 1
Rank 1
answered on 24 May 2011, 11:15 AM
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
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
0
Clyde
Top achievements
Rank 1
Rank 1
answered on 27 May 2011, 03:18 PM
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.