Advanced Edit or Insert Form Slow load times

4 posts, 0 answers
  1. Michael
    Michael avatar
    18 posts
    Member since:
    Nov 2007

    Posted 30 Mar 2011 Link to this post

    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>

     

  2. Peter
    Admin
    Peter avatar
    6637 posts

    Posted 04 Apr 2011 Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. Infinity Tech
    Infinity Tech avatar
    1 posts
    Member since:
    Jun 2010

    Posted 06 Jul 2011 Link to this post

    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
  4. Peter
    Admin
    Peter avatar
    6637 posts

    Posted 12 Jul 2011 Link to this post

    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

    Register for the Q2 2011 What's New Webinar Week. Mark your calendar for the week starting July 18th and book your seat for a walk through of all the exciting stuff we will ship with the new release!

Back to Top