Advanced Edit or Insert Form Slow load times

[Michael]

Hello,

How do I improve the load times of the Advanced Edit/Insert forms. I really need the Recurrance control but the load time is terrible. With a basic setup and no appointments on the Scheduler it still takes 5-6 seconds to load. I am also seeing the same response time on your demo pages. I also get the same results in my Dev environment as well as Production regardless of the form being modal or not or if debugging is on or off. I have read the posts on how to improve performance but they mostly relate to improving loading of appointments. I am seeing this response time with no appointments.There has got to be a way to make this faster?? Below is my basic setup. I am using 2010.3.1317.40 release. Thank you!

<

 

 

telerik:RadScheduler runat="server" ID="RadScheduler2" Width="750px" TimeZoneOffset="03:00:00"

 

 

 

    SelectedDate="2007-03-30" DayStartTime="08:00:00" DayEndTime="18:00:00" EnableViewState="false"

 

 

 

 

    StartInsertingInAdvancedForm="true" StartEditingInAdvancedForm="true"

 

 

 

    SelectedView="MonthView" DataKeyField="ID" DataSubjectField="Subject" DataStartField="Start"

 

 

 

    DataEndField="End" DataReminderField="Reminder" DataRecurrenceField="RecurrenceRule"

 

 

 

    DataRecurrenceParentKeyField="RecurrenceParentID" DataSourceID="AppointmentsDataSource"

 

 

 

    Reminders-Enabled="false" Skin="Telerik">

 

 

 

    <AdvancedForm Modal="false" />

 

 

 

    <ResourceTypes>

 

 

 

    <telerik:ResourceType KeyField="ID" Name="Room" TextField="RoomName" ForeignKeyField="RoomID" 
        DataSourceID="RoomsDataSource" />

 

 

 

    <telerik:ResourceType KeyField="ID" Name="User" TextField="UserName" ForeignKeyField="UserID"

 

 

 

        DataSourceID="UsersDataSource" />

 

 

 

    </ResourceTypes>

 

 

 

    <TimeSlotContextMenuSettings EnableDefault="true" />

 

 

 

    <AppointmentContextMenuSettings EnableDefault="true" />

 

 

 

</telerik:RadScheduler>

 

<

 

 

asp:SqlDataSource ID="AppointmentsDataSource" runat="server"

 

 

 

 

    ConnectionString="<%$ ConnectionStrings:Team_ConnectionString %>"

 

 

 

 

    OnSelecting="AppointmentsDataSource_Selecting" OnSelected="AppointmentsDataSource_Selected"

 

 

 

    SelectCommand="SELECT * FROM [TEMP_SCHDTEST] WHERE ([Start] < @RangeEnd AND [End] > @RangeStart) OR ([RecurrenceRule] <> '') OR ([RecurrenceParentID] IS NOT NULL)"

 

 

 

 

    InsertCommand="INSERT INTO [TEMP_SCHDTEST] ([Subject], [Start], [End], [UserID],

 

 

        [RoomID], [RecurrenceRule], [RecurrenceParentID], [Annotations], [Description], [Reminder],

 

        [LastModified]) VALUES (@Subject, @Start, @End, @UserID, @RoomID, @RecurrenceRule,

 

        @RecurrenceParentID, @Annotations, @Description, @Reminder, @LastModified)"

 

 

    UpdateCommand="UPDATE [Appointments] SET [Subject] = @Subject, [Start] = @Start, [End] = @End,

 

 

        [UserID] = @UserID, [RoomID] = @RoomID, [RecurrenceRule] = @RecurrenceRule,

 

        [RecurrenceParentID] = @RecurrenceParentID, [Annotations] = @Annotations, [Description] =     @Description, [Reminder] = @Reminder, [LastModified] = @LastModified WHERE [ID] = @ID"

 

 

    DeleteCommand="DELETE FROM [TEMP_SCHDTEST] WHERE [ID] = @ID">

 

 

 

<SelectParameters>

 

 

 

    <asp:Parameter Name="RangeStart" Type="DateTime" DefaultValue="1900/1/1" />

 

 

 

    <asp:Parameter Name="RangeEnd" Type="DateTime" DefaultValue="2900/1/1" />

 

 

 

</SelectParameters>

 

 

 

<DeleteParameters>

 

 

 

    <asp:Parameter Name="ID" Type="Int32" />

 

 

 

</DeleteParameters>

 

 

 

<UpdateParameters>

 

 

 

    <asp:Parameter Name="Subject" Type="String" />

 

 

 

    <asp:Parameter Name="Start" Type="DateTime" />

 

 

 

    <asp:Parameter Name="End" Type="DateTime" />

 

 

 

    <asp:Parameter Name="UserID" Type="Int32" />

 

 

 

    <asp:Parameter Name="RoomID" Type="Int32" />

 

 

 

    <asp:Parameter Name="RecurrenceRule" Type="String" />

 

 

 

    <asp:Parameter Name="RecurrenceParentID" Type="Int32" />

 

 

 

    <asp:Parameter Name="Annotations" Type="String" />

 

 

 

    <asp:Parameter Name="Description" Type="String" />

 

 

 

    <asp:Parameter Name="Reminder" Type="String" />

 

 

 

    <asp:Parameter Name="LastModified" Type="String" />

 

 

 

    <asp:Parameter Name="ID" Type="Int32" />

 

 

 

</UpdateParameters>

 

 

 

<InsertParameters>

 

 

 

    <asp:Parameter Name="Subject" Type="String" />

 

 

 

    <asp:Parameter Name="Start" Type="DateTime" />

 

 

 

    <asp:Parameter Name="End" Type="DateTime" />

 

 

 

    <asp:Parameter Name="UserID" Type="Int32" />

 

 

 

    <asp:Parameter Name="RoomID" Type="Int32" />

 

 

 

    <asp:Parameter Name="RecurrenceRule" Type="String" />

 

 

 

    <asp:Parameter Name="RecurrenceParentID" Type="Int32" />

 

 

 

    <asp:Parameter Name="Annotations" Type="String" />

 

 

 

    <asp:Parameter Name="Description" Type="String" />

 

 

 

    <asp:Parameter Name="Reminder" Type="String" />

 

 

 

    <asp:Parameter Name="LastModified" Type="String" />

 

 

 

</InsertParameters>

 

 

 

</asp:SqlDataSource>

 

[Peter]

Hello Michael,

We are aware of this problem, but unfortunately, there isn't much you can do to improve performance with the current advanced form. We will schedule a thorough review of the code of the advanced form and do our best to make it faster for the Q2 2011 release.

Please, accept our apologies for this flaw with RadScheduler.


Kind regards,
Peter
the Telerik team

[Infinity Tech]

Can anyone speak to the status of this issue?  It says maybe something in Q2-2011 but I don't see anything in the release notes.

I have exactly the same issues in a situation with "10s" of custom fields.  My customer is complaining that it takes too long to create/update appointments and I'm looking for options.

Thanks
James Hildeman

[Peter]

Hello,

Unfortunately, we haven't included performance improvement of the advanced form in our task list for Q2 2011.
Please, accept our apologies for any caused inconvenience.

Regards,
Peter
the Telerik team