How does the scheduler manage data?

[Peng Hock Lee]

Hi,

I am currently having a problem migrating data from my previous scheduler to your scheduler. My problem is mostly on the performance issue I am facing.
That is why I would like to know, how does telerik scheduler manage data loading?

for example
my scheduler uses recurrence function and it is bind to a sqldatasource using early binding method. and the sqldatasource statement is "SELECT * FROM myTABLE WHERE EVENTTYPE = 5"
and i set the selected date of my scheduler to 2008 Oct 06.

now here is my question,
1. does it load every data where the eventtype = 5 and store it on the buffer on the first run, and only shows data which is in the date range of my scheduler in this case 2008 Oct 05 until 2008 Oct 11,

2. or doest it automatically load data where the eventtype = 5 and startdate > 2008 Oct 05 and startdate < 2008 Oct 11?

3. if you use the 2nd type of data loading, how do you handle data that start before 2008 Oct 05, but recurs until 2008 Oct 12?



How does the scheduler optimised the data loading that's cover the occurence events to display the desire result set out for day view, week view and month view.  My concerns is that the performance may drop as the pointer need to start from record 1 to last record in order to handle the occurence events.

[T. Tsonev]

Hello Peng,

By default, RadScheduler will not perform filtering on the data coming from the data source. Ultimately, it will ignore appointments outside of the visible range, but they will still be in the appointments collection.

We have an example that demonstrates how this filtering can be done at the data source:

http://demos.telerik.com/aspnet/prometheus/Scheduler/Examples/OptimizedQueries/DefaultCS.aspx

What it basically does is to select all appointments in the visible range plus all recurring appointments. We need to read the recurring appointments unconditionally, as we cannot "guess" whether they will occur in the visible range or not without parsing the rule first.

An alternative would be to process the recurring appointments on the SQL server. We have such sample for SQL Server 2005 (and up) that evaluates the recurrence rules in a managed stored procedure. More info here:

http://blogs.telerik.com/TsvetomirTsonev/Posts/08-08-04/Working_with_RadScheduler_recurring_appointments_on_SQL_server.aspx

All the best,
Tsvetomir Tsonev

[Simon]

Hi Peng,

I am following up in this support ticket with the following request:

May I have your permission to convert this ticket into a forum thread, so that other members of the community see its content.

Your question is very interesting and and others could benefit from the response as well.

Please let me know what do you think.

Sincerely yours,
Simon
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[Peng Hock Lee]

Hi,

By all means, please go ahead to convert to forum thread if you think it benefit the other members of the communities.

Thanks and Warm Regards, Always
Lee Peng Hock